Parsing text

[Guest]

Please. Does anyone have the code to parse text. ie each cell has Christian
name followed by surname. What I would like to do is iether pick out the
surname and plonk it in font of the Christian name(preferable) or pop it into
another cell. Just to make it a bit harder, I need to do it for a range of
cells, say, everything in the "A" column.
Thanks in advance

 

[David Biddulph]

Have you tried Data/ Text to columns?

 

[Guest]

Could be "no problem", or could be a nightmare..........depends on how your
names are entered.....if they are all Firstname space Lastname, then just
highlight the column and do Data > TextToColumns > Delimited > and use space
for the delimiter......just be sure the column next to your name column is
blank, if not, insert a new one...........

If your namelist is inundated with Mr. Mrs., middle initials, titles, etc,
and are not all the same way.......those things will have to be straigntened
out first.........in that case, post back with more details and someone will
help.

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thanks guys. Easy peasy when you know how

Have you tried Data/ Text to columns?