Split one cell into 2 ?

vertisol

Board Regular
Joined
Jun 23, 2002
Messages
55
I have tried searching on allsorts of keywords but to no avail.

In column A I have a list of names in the format "FirstName LastName" separated by a space. What I would like to do is put the last name into column B automatically.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

SamS

Well-known Member
Joined
Feb 17, 2002
Messages
542
Hi vertisol, try - select the column of data>Data>Text to Columns>Delimited>Check the Space box and the 2 names will be separated into separate columns - you will need a spare column to the right of your data

_________________<font size=+1.<fontcolor="Blue">Sam</font size=+1.</fontcolor="Blue">
Why is it that the nuttiest people define reality?
This message was edited by SamS on 2002-09-25 22:44
 

anno

Board Regular
Joined
Feb 16, 2002
Messages
202
vertisol
have a look at text to columns (data menu). it allows you to split a column of cells using delimiters such as spaces, commas etc. if there are spaces between firstname and lastname you can specify a space as the delimiter, then just reverse the position of the columns.
hth
This message was edited by anno on 2002-09-26 00:16
 

Forum statistics

Threads
1,144,290
Messages
5,723,522
Members
422,502
Latest member
barakgahtan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top