working inside a cell


G

Guest

I have a column that has a list of people last name first, first name. And another column that has the name of the person first name and then last name

Is there a way to transpose the information without having to retype everything? for example

Smith, Tom is there a way to enter a formula and make the cell read: Tom Smith or vice-versa

Please advice

Thank you.
 
Ad

Advertisements

Ad

Advertisements

B

BrianB

Need to make a new column with a formula like :-
=RIGHT(A1,LEN(A1)-FIND(",",A1,1))&" " &LEFT(A1,FIND(",",A1,1)-1)

Then select the column, and Copy.
Edit/Paste Special/Values.
Delete the original column
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fonts Inside of Cells 3
Entering inside a cell?? 1
scrolling inside a cell 4
Symbols inside cells 2
Macro Inside Cell 3
Tabs inside the cell 2
"Tab" inside an Excel cell 2
HOW TO COUNT INSIDE A CELL 5

Top