Extracting Words from Cells
If the first and last names are separated by a space and/or a comma, then
consider using Text to Columns
--
Gary''s Student
gsnu200706
"Tommy" wrote:
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?
|