Concatenation

[Guest]

Hi there

I have a field that reads "last name, first name
I would like it to read "first name*last name
How can I set up the formulae

thanks in advance.

 

[Anders S]

Cynthia,

One way,

=MID(A1,FIND(",",A1)+2,1000)&"*"&LEFT(A1,FIND(",",A1)-1)

HTH
Anders Silvén

 

[Guest]

Thanks!!!!! it worked.