Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change name in single cell from last, first to first last
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change name in single cell from last, first to first last
You can't do it directly unless you use a macro. The easiest was is to flip
the names around with a formula and then copy / paste special - values the correct names over top of the original... The formula could be something like this... =MID(A1,FIND(",",A1)+2,256)& " " & LEFT(A1,FIND(",",A1)-1) -- HTH... Jim Thomlinson "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 ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change height and width of a single cell | Excel Discussion (Misc queries) | |||
Calculate amount of change in a single cell | Excel Discussion (Misc queries) | |||
Single Cell change size | Excel Discussion (Misc queries) | |||
change first-name-last to last-name-first in a single cell? | Excel Worksheet Functions | |||
How to change single cell width | Excel Worksheet Functions |