separate text string
The TextToColumns as previously described is the best procedure to do this
sort of thing, but be sure and check your results..........if the 600 rows
have been hand-entered, for sure there is a mistake somewhere along the line
which will need to be corrected...............no comma, two commas, etc etc
Vaya con Dios,
Chuck, CABGx3
"HRA1" wrote:
I have a text string as follows LAST NAME, FIRST NAME
Smith, John.
I need to put the last name in one column and the first name in another
column. I can do it for one cell using the left or right formula. But I have
600 cells and can't figure out the formula to copy down for the rest of the
cells.
Thank you.
|