Swap lastname, firstname in excel field

[bygeek]

I have a database I'm importing into Excel. The names are in one field listed as Lastname, Firstname. Is there any easy way to change the order in the field to Firstname Lastname before I export it to Outlook contacts?

 

[SkipVought]

Hi,

I assume that the last & First are separated by a comma, WITHOUT FAIL.

In your original Query...

Select .... trim(left([Name],instr([Name],',')-1)) as Last, trim(right([Name],len([Name])-instr([Name],','))) as First

Skip,

_{[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie!}

 

[GoDawgs]

Try this formula in Excel (with I14 being the "Lastname, Firstname" cell):

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

Hope that helps.

Kevin

 

[bygeek]

GoDawgs, I tried yours first and it worked like a charm! No offense, SkipVought, I'm sure your would have worked also, just did what was easiest for me.