Name direction

[mindah26]

ray: How do I change the name JOHN SMITH to SMITH, JOHN?[/b]

 

[BuddieB]

Assuming the original value is in A1, put this formula in B1:

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

but this might not include if there are any name prefixes.

 

[Andrew Poulsom]

Like this:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))&", "&LEFT(A1,FIND(" ",A1)-1)

where A1 contains the original text.

 

[BuddieB]

Andrew... is it better to use Search or Find? Do you have a preference?

 

[north19701]

FIND is case sensitive while SEARCH is not

 

[BuddieB]

FIND is case sensitive while SEARCH is not

thanks, good to know.

 

[north19701]

in this instance, though, either one would work fine.