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.
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
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
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.
