Extracting Info From Cells

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!
 
D

Don Guillett

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.
 
V

Vødkäjéllÿ

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.
 
E

excelexpert1973

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
 

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

Extracting Words from Cells 2
Using lookup formula using more than one cell 5
Cut and paste macro 1
I copied Visible Cells Only, but it pastes only the first cell 1
Extracting data from range and placing in one cell with comma'sbetween while ignoring blanks 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Select certain cells in a column 2
Possible to select a string in a locked cell? 1

Top