Flip data within cell macro

[Dan Royal]

My wife inherited a spreadsheet in which column A has peoples names in the
format of John Doe. She needs to change those all to format Doe John. I've
been trying to write a macro to do this but haven't been successful. Any
ideas?

Thanks,

Dan

 

[Jean Ruch]

My wife inherited a spreadsheet in which column A has peoples names in the
format of John Doe. She needs to change those all to format Doe John. I've
been trying to write a macro to do this but haven't been successful. Any
ideas?

Thanks,

Dan

Hello Dan,

Under the Menue "Data" you have the option "Text in columns".

Applying it to the Columns where the names are (let's suppose it is A:A),
your wife gets the first and last names in separated columns
For that, the wizzard asks her how her Datas are separated
(=Space in her case)

With the Formula in C1 : = B1 &" "& A1
/ Copy / Paste values, she also gets the result she wants

regards

Jean

 

[news.microsoft.com]

Hello Dan,

Under the Menue "Data" you have the option "Text in columns".

Applying it to the Columns where the names are (let's suppose it is A:A),
your wife gets the first and last names in separated columns
For that, the wizzard asks her how her Datas are separated
(=Space in her case)

With the Formula in C1 : = B1 &" "& A1
/ Copy / Paste values, she also gets the result she wants

Bear in mind if you have double barrelled names in there, a space won't
necessarily give valid results in such automatic checks.

It really annoyed me when my bank did this and gave me an argument when
I told them they had my name wrong. They ended up losing the account.

 

[Jean Ruch]

Hello Dan,

Should interest your wife for more complicated cases ( unfortunately :
for the German version)

http://spotlight.de/nzforen/mse/m/mse-1062790923-13759.html

kind regards

Jean