Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
splitting cells
Is there a way to split a cell containing the following information
eyerly david j eyerly jennifer k which is = to last name First Middle Int. Last Name First Middle Int. So i want the last name in one column and the first in another and i dont need the middle initial but if its easier to keep it when splitting that is find. My main focus is to get the last name in on cell. Thank you, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
splitting cells
DataText To Columns with space as a delimiter
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Nicole" wrote in message ... Is there a way to split a cell containing the following information eyerly david j eyerly jennifer k which is = to last name First Middle Int. Last Name First Middle Int. So i want the last name in one column and the first in another and i dont need the middle initial but if its easier to keep it when splitting that is find. My main focus is to get the last name in on cell. Thank you, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
splitting cells
Hi
One way is to use Data/Text to columns. Make a backup before you start, highlight your column and use delimited and <space as the delimiter. Hope this helps. Andy. "Nicole" wrote in message ... Is there a way to split a cell containing the following information eyerly david j eyerly jennifer k which is = to last name First Middle Int. Last Name First Middle Int. So i want the last name in one column and the first in another and i dont need the middle initial but if its easier to keep it when splitting that is find. My main focus is to get the last name in on cell. Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
Split Long Text Cell into Two Shorter Cells Without Splitting Word | Excel Discussion (Misc queries) | |||
splitting and rejoining text in cells | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |