Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing first and last names in one cell
Is there a way I can reverse first and last names in Excel when the first and
last name is within one cell? When my software exports it last name, first name it brings it into one cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing first and last names in one cell
With a name in A1 use:
=REPLACE(A1&" "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"") -- Gary''s Student - gsnu200781 "Té" wrote: Is there a way I can reverse first and last names in Excel when the first and last name is within one cell? When my software exports it last name, first name it brings it into one cell. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing first and last names in one cell
Thank you Gary. Do I have to put this formula in every cell where I have
names? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing first and last names in one cell
It wouldn't be any good putting it in the cell where you have names, because
you would then be over-writing the names with your formula. Put the formula somewhere else; an adjacent column is often most convenient. In answer to the question which I think you may have intended to ask, then yes, you need a copy of the formula referring to each cell from which you want the answer. You have at least 3 options: Copy the original formula and then paste down the rest of the column. Select the bottom right-hand corner of the cell and the cursor will turn into a + which then works as a "fill handle" which you can drag down the column. If your formula is adjacent to your original data column, double-clicking on the fill handle will fill the formula down the column as far as there is contiguous data. -- David Biddulph "Té" wrote in message ... Thank you Gary. Do I have to put this formula in every cell where I have names? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing first and last names in one cell
Thank you!!!!
"David Biddulph" wrote: It wouldn't be any good putting it in the cell where you have names, because you would then be over-writing the names with your formula. Put the formula somewhere else; an adjacent column is often most convenient. In answer to the question which I think you may have intended to ask, then yes, you need a copy of the formula referring to each cell from which you want the answer. You have at least 3 options: Copy the original formula and then paste down the rest of the column. Select the bottom right-hand corner of the cell and the cursor will turn into a + which then works as a "fill handle" which you can drag down the column. If your formula is adjacent to your original data column, double-clicking on the fill handle will fill the formula down the column as far as there is contiguous data. -- David Biddulph "Té" wrote in message ... Thank you Gary. Do I have to put this formula in every cell where I have names? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing first and last names in one cell
This formula works. Thanks for sharing it.
"Gary''s Student" wrote: With a name in A1 use: =REPLACE(A1&" "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"") -- Gary''s Student - gsnu200781 "Té" wrote: Is there a way I can reverse first and last names in Excel when the first and last name is within one cell? When my software exports it last name, first name it brings it into one cell. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reversing first and last names in one cell
I can't see the original thread (so I don't know if I already offered this
solution to you or not), but here is another solution you may want to consider... Assuming there is always a space after the comma... =MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1) otherwise (which will work if the space is there or not)... =TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1))) -- Rick (MVP - Excel) -- Rick (MVP - Excel) "Kumar" wrote in message ... This formula works. Thanks for sharing it. "Gary''s Student" wrote: With a name in A1 use: =REPLACE(A1&" "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"") -- Gary''s Student - gsnu200781 "Té" wrote: Is there a way I can reverse first and last names in Excel when the first and last name is within one cell? When my software exports it last name, first name it brings it into one cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell names = sheet names | Excel Worksheet Functions | |||
Reversing Last Name and First Names | Excel Discussion (Misc queries) | |||
Reversing First and Last Names | Excel Discussion (Misc queries) | |||
Reversing cell values | Excel Discussion (Misc queries) | |||
Reversing First & Last Name | Excel Worksheet Functions |