Extracting Info From Cells

  • Thread starter Thread starter Tommy
  • Start date Start date
T

Tommy

I would like to extract the last names from a group of cells
containing a first and last name and place them into a separate
column. Is there an easier way to accomplish this other than
highlghting the last name and using cut&paste to move into the new
cell?
Thanks!
 
Have a look in the help index for FIND to see how to separate using a
formula. Or, use data>text to columns for space or comma. Or, use a macro.
 
Tommy said:
I would like to extract the last names from a group of cells
containing a first and last name and place them into a separate
column. Is there an easier way to accomplish this other than
highlghting the last name and using cut&paste to move into the new
cell?
Thanks!
Click to expand...

Select column
Click 'DATA' from toolbar menu
Choose 'Text to columns' in the drop down list
check 'Delimited'
NEXT
check the 'Space' box
NEXT
NEXT
FINISH
This will split your data in the right place.

You can always record a macro so that next time it happens with one click of
the macro button.

So you could split the data, move it to other columns, delete the original
column, even add formulas and save the sheet, all in the same macro.
 
I would like to extract the last names from a group of cells
containing a first and last name and place them into a separate
column. Is there an easier way to accomplish this other than
highlghting the last name and using cut&paste to move into the new
cell?
Thanks!
Click to expand...
*********************************
I assume that each first name and last name are in the same cell like
"John Doe". If that is the case, select the column containing the data
and on the menu bar, go to

Data >>> Text to Columns >>> Select Delimited >>> Click Next >>>
Select SPACE >>> Click Finish.

This should split John Doe to 2 seperate columns.

Best
Prasad
 
Back
Top