Split text at space
 

Hello
Is there a simple formula to split col A data (Palm Beach in A1) to Palm in
b1 and Beach in c1
With thanks
John

Split text at space
 

Try these...

B1: =LEFT(A1,FIND(" ",A1)-1)

C1: =SUBSTITUTE(A1,B1&" ","")

--
Biff
Microsoft Excel MVP


"Father John" wrote in message
...
Hello
Is there a simple formula to split col A data (Palm Beach in A1) to Palm
in b1 and Beach in c1
With thanks
John

Split text at space
 

--Select the range/column needs to be changed. From menu DataText to Columns
will populate the 'Convert Text to Columns Wizard'. By default the selection
is 'Delimited'. Keep the selection and hit 'Next'. From the Step2 of the
Wizard from the options select Space and hit Next. Hit Finish

--Another way (single formula). Try the below formula in cell B1 and copy
the same to cell C1.

=TRIM(MID(SUBSTITUTE(" " & $A$1& REPT(" ",6),"
",REPT(CHAR(32),255)),COLUMNS($B$1:B$1)*255,25 5))

--
Jacob


"Father John" wrote:

Hello
Is there a simple formula to split col A data (Palm Beach in A1) to Palm in
b1 and Beach in c1
With thanks
John

.