splitting forename and surname

C

cal

i have a sheet with a column containing both forenames and surnames (with a
space in between) in the same cell.
can i split this into two columns, so that i can sort the list by surname?

tia
cal
 
D

Dave Peterson

Insert a new column to the right
select your column with the data
data|text to columns
delimited
by a space character.
 
C

cal

nice one dave - you don't know how much time this has saved me.
thanks mate

| Insert a new column to the right
| select your column with the data
| data|text to columns
| delimited
| by a space character.
|
| cal wrote:
| >
| > i have a sheet with a column containing both forenames and surnames
(with a
| > space in between) in the same cell.
| > can i split this into two columns, so that i can sort the list by
surname?
| >
| > tia
| > cal
|
| --
|
| Dave Peterson
 

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

linking to other worksheets and updating a file 1
splitting forenames/surnames into separate columns 2
Get Title, Forename(s) and Surname 2
Splitting Forename & Surname in one cell 2
moving first word in a column to a separate column 8
how do i convert names to initials in excel 2
Sorting by surname when first name and surname are in the same cel 2
Merging 2 spreadsheets 1

Top