Thank you so much - this worked awesomely! ?
I had a hunch you guys would come through with a solution much faster than I would.
What I did was use find/replace to change ¡°Display Name¡± to ¡°First Name¡±, ¡°Last Name¡±?
then I had to add in another field to the header line to account for the additional field in the csv
Here is the blow by blow:
Download the membership list (it listed the csv data on the web page I was using)
either save to a file OR select all & copy/paste to a text file (both ways worked)
cut out the header data line of the csv & save it somewhere (like in another text file)
use find/replace to change all spaces to comma quote comma (,¡±,)?
go get that header line and paste it back in
edit the header to add in the new field (I changed Display Name to First Name and added ,¡°Last Name¡±, )
save the file
in Numbers (excell) I just opened the csv file and it worked
I¡¯m just giddy over this - our group is a quilt group. I¡¯m 60 & one of the youngest, they have been razzing me for months about my sign in sheets sorted by first name - boy will they be surprised at our next meeting!!
Night Owls Owner