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

String Search 3
splitting forenames/surnames into separate columns 2
VBA - exporting serial letters to single documents 0
moving first word in a column to a separate column 10
Combine 2 columns in a dynamic range into one 7
Combining forename and surname fields in report 6
Merging 2 spreadsheets 1
Index Match to add employee number 2

Top