Change Firstname and Lastname position

[BOGIA]

Hi all,

I need to change position of Firstname and Lastname.

Eg: Bill Smith becomes SmithB
Helen Clinton becomes ClintonH

Either VBA code or Function to do the job would be good.

Thanks in advanve.

Cheers Bogia

 

[NateO]

Hello,

Try something like the following:

=MID(A1,FIND(" ",A1)+1,LEN(A1))&LEFT(A1,1)

And please post back when you realize that you've drastically over simplified the potential array of names you need to parse. :wink:

 

[BOGIA]

Hi NateO,

Excellent, It works. You save me a big time. Thanks alots.

cheers bogia

 

[NateO]

You are welcome.