Flip data within cell macro

  • Thread starter Thread starter Dan Royal
  • Start date Start date
D

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
 
Dan Royal said:
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
Click to expand...


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
 
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
Click to expand...

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.
 
Back
Top