Question for Excel or Access

[dmaier]

Is there a way to reverse or juxtapose(I guess that is the word) a column of names....

Example: Bob Miller

Change to Miller, Bob

Do this for a whole column of names. Can this be done?

 

[SkipVought]

Hi,

You can create a formula to do that...
[tt]
=RIGHT(A1,LEN(A1)-FIND(" ",A1))&", "&LEFT(A1, FIND(" ",A1)-1)
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[byundt]

See the second example in Dave Brett's file at

http://www.vbaexpress.com/kb/getarticle.php?kb_id=68

He uses RegExp in a VBA macro to do the name reversal.