| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Easy one for the Pros!
I've got a single cell containing a first and last name, seperated by a
space. I need to break it into two cells: I've got I need Cell1 Cell2 Cell3 John Doe John Doe I was thinking my formula would be: =Left(A1,Find(" ",A1)25) But no joy... Thanks in advance! steve |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Easy one for the Pros!
Hi
first name =LEFT(A1,FIND(" ",A1,1)-1) second name =MID(A1,FIND(" ",A1,1)+1,9999) Mike "sjs" wrote: I've got a single cell containing a first and last name, seperated by a space. I need to break it into two cells: I've got I need Cell1 Cell2 Cell3 John Doe John Doe I was thinking my formula would be: =Left(A1,Find(" ",A1)25) But no joy... Thanks in advance! steve |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Easy one for the Pros!
First name:
=Left(A1,Find(" ",A1)-1) Last name: =MID(A1,FIND(" ",A1)+1,LEN(A1)-FIND(" ",A1)) On Nov 14, 1:56 pm, sjs wrote: I've got a single cell containing a first and last name, seperated by a space. I need to break it into two cells: I've got I need Cell1 Cell2 Cell3 John Doe John Doe I was thinking my formula would be: =Left(A1,Find(" ",A1)25) But no joy... Thanks in advance! steve |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Easy one for the Pros!
Use datatext to columns (make a backup of the file first), use space as
delimiter and make sure the adjacent column to the right is empty or =Left(A1,Find(" ",A1)-1) assume you put that formula in B1, in C1 use =TRIM(SUBSTITUTE(A1,B1,"")) -- Regards, Peo Sjoblom "sjs" wrote in message ... I've got a single cell containing a first and last name, seperated by a space. I need to break it into two cells: I've got I need Cell1 Cell2 Cell3 John Doe John Doe I was thinking my formula would be: =Left(A1,Find(" ",A1)25) But no joy... Thanks in advance! steve |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Easy one for the Pros!
Thanks everyone, I appreciate your help!!
steve "Peo Sjoblom" wrote: Use datatext to columns (make a backup of the file first), use space as delimiter and make sure the adjacent column to the right is empty or =Left(A1,Find(" ",A1)-1) assume you put that formula in B1, in C1 use =TRIM(SUBSTITUTE(A1,B1,"")) -- Regards, Peo Sjoblom "sjs" wrote in message ... I've got a single cell containing a first and last name, seperated by a space. I need to break it into two cells: I've got I need Cell1 Cell2 Cell3 John Doe John Doe I was thinking my formula would be: =Left(A1,Find(" ",A1)25) But no joy... Thanks in advance! steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy one for you pros! | Excel Worksheet Functions | |||
| Pros and Cons of embedding Excel Workbook object in PPT Presentati | Excel Discussion (Misc queries) | |||
| Help Excel Data manipulation Pros: Something like a Vlookup with a Sum Function | Excel Worksheet Functions | |||
| I'm sure this is an easy one, but.... | Excel Worksheet Functions | |||
| new user with easy question? not easy for me | New Users to Excel | |||
Linear Mode
