In MS Excel, is there a way to...?

Question

...make this: Smith,John
...into this: John Smith
...r this: Smith Family

I have 3250 cells to convert. Is there a way to do it without doing it manually?

Answer 1

Wouldn't it be easier to do it in one cell, copy it, highlight the cells you want to replace and paste? If you look in the formula's, there is one called either replace or substitute (can't remember which) and it will do what you are looking for but it takes some time to figure it out exactly.

Answer 2

1. I make the following assumptions before I start: A) all of the names you need to convert are in the same vertical column. For instance, cell A1="Smith, John". Cell A2="Johnson, Bob". Cell A3="Jones, Mary". B) all names are in the format LastName, FirstName. This function will not work if the comma is missing, if there is more than one comma in the name, or if there are more or fewer than one blank space after the comma. C) none of the names to be converted are longer than 30 characters.

2. In the top cell in a new column that's currently not being used for anything else, copy and paste the following function: =CONCATENATE(MID(A1, (FIND(",", A1))+2, 30)," ",LEFT(A1, (FIND(",", A1))-1))

3. This will take "Smith, John" in cell A1 and turn it into "John Smith". You can copy the function down the column by clicking the cell in which you pasted the function, which highlights it, and then click-and-hold the lower right-hand corner of the highlighted cell and drag it down the column as far as you want to convert all the cells in the first column.

4. If the names to be converted are in a column other than the first one, change all references to "A1" in the function to "B1" for the second column, "C1" for the third column, etc.

Answer 3

Looks like you got the older version.

Try installing office 2003 or the office 2007

Answer 4

Most of the answers are wrong. I think the only way to do it is combination of formulas or VBA.

Answer 5

On your toolbar next to sort ascending, is the button for your needs, Highlight the entire column and choose sort by ? whatever options you want...good luck

Answer 6

You can write Excel VBA function.

Answer 7

START TYPING THEM ALL OVER AGAIN!

Answer 8

please elaborate more