I have a spreadsheet with first and last names in one cell. I would like to
sort by last names. Is there any way to sort by the second word in a cell or
a quick way to divide the cell by first and last names, without cut and paste?
I have a spreadsheet with first and last names in one cell. I would like to
sort by last names. Is there any way to sort by the second word in a cell or
a quick way to divide the cell by first and last names, without cut and paste?
Save your data first, and make sure there is a blank column (or two) to the
right of the column with your data in it........then Highlight the column of
names..........then Data > Text to columns > delimited > next > check
"space" for a delimiter > next > finish......
Vaya con Dios,
Chuck, CABGx3
"crc-src" <[email protected]> wrote in message
news:[email protected]...
> I have a spreadsheet with first and last names in one cell. I would like
to
> sort by last names. Is there any way to sort by the second word in a cell
or
> a quick way to divide the cell by first and last names, without cut and
paste?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks