| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I unwrap text to columns? | Excel Discussion (Misc queries) | |||
| Text to columns - one way street? | Excel Discussion (Misc queries) | |||
| How do I convert from text to columns automatically on import? | Excel Discussion (Misc queries) | |||
| comparing columns of text (cross-searching) | Excel Discussion (Misc queries) | |||
| Text to columns | Excel Discussion (Misc queries) | |||
Threaded Mode
