How do I change name in single cell from last, first to first last
Hi,
You can't really do what your asking without VBA. What you can do with a
formula is:
You can enter this in another cell and then copy and paste it over the old
text as values. In this example D1 contains the Last, First name
=MID(D1&" "&D1,FIND(",",D1)+2,LEN(D1)-1)
Copy this, select cell D1 and choose Edit, Paste Special, Values.
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Dreamy" wrote:
In Excel 2003 how do I change a name in single cell that is last, first to a
first last name still in the same cell ?
|