Text to Columns

N

NewKid

I have a list of names that were split across 3 columns using the text to
columns feature. Does anyone know of an EASY way to tell Excel to move a
name into the third position if it is blank?

Example:
A B C
1 LastName MiddleInitial FirstName
2 Smith J Daniel
3 Taylor David
4 Pearson Tony

I have thousands of records and would like to find a way to quickly move
contents from the 2nd column to the 3rd IF that 3rd column is blank.

Idea's anyone?
Thanks!
NewKid
 
C

CLR

In cell D2 put the following formula and copy it down as many rows as you
have data in columns A and B....

=IF(C2="",B2,C2)

Then do Copy > PasteSpecial > Values on the column D and delete the old
column C.....

Vaya con Dios,
Chuck, CABGx3
 
N

NewKid

Thank you SO much! I should have thought of that! That is awesome.
Thanks again!!
NewKid.
 

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

Combination of text in 2 columns 4
Text to Columns Problem 4
Colour Coding dates 6
I have Text in a Colunm but want to sort ... 4
String Search 3
moving first word in a column to a separate column 10
Separating First Name(s) and Last Name into Separate Columns 3
Extract Name from Text 4

Top