Parsing text
 

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

Parsing text
 

Have you tried Data/ Text to columns?
--
David Biddulph

"Hamster07" wrote in message
...
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

Parsing text
 

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



"Hamster07" wrote:

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

Parsing text
 

Thanks guys. Easy peasy when you know how

"David Biddulph" wrote:

Have you tried Data/ Text to columns?
--
David Biddulph

"Hamster07" wrote in message
...
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