How do I separate ‘FName,LName’ (1 cell) to ‘LName’ , ‘FName’ (2 cells)?
Data>Text to columns…
Separator = comma
Got it;
- Replace space with comma
- Copy column with FNAME,LNAME
- Copy to new sheet using PASTE SPECIAL and un√ all except COMMA into cols A, B, (C if necessary)
- Use =CONCAT(B1,C1,A1,"@xxx.com") in column D
- Copy down to end of list
- Copy new list (LNameFName)
Done !
Thanks,
⌡im [THE BookMan]
920.265.5966