Text Manipulation

  • Thread starter Thread starter RON
  • Start date Start date
R

RON

I have large data file that contains one column of text
i.e. Abkarian Shaghzo & Marty. I would like to create
additional columns and separate this information into:
Column A=LastName "Abakarian, Column
B=FirstName "Shaghzo", and column
C=SousesFirstName "Marty". I have been told that each
column of text can be formated using formulas or
functions. This beats changing each cell separately. The
question is how do I do this? Is there a book or short
course available that list all of the formulas or
functions that will allow me to manipulate text in cells.

another example of what I need to do would be: change the
content of cells i.e. "Browning, Arthur" to read "Arthur
Browning"

If you can provide me with any help or direction on how
find the necessary resources to work through these issues
iwould appreciate it.
 
Ron

As your first try, I'd use Data/Text to columns and use a space as
delimiter. That should give you a close fit.

Andy.
 
Back
Top