Split text at space

  • Thread starter Thread starter Father John
  • Start date Start date
F

Father John

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
 
--Select the range/column needs to be changed. From menu Data>Text 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,255))
 
Back
Top