Split text at space

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
 
J

Jacob Skaria

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I move data to a new line in a cell after a comma? 9
right, mid, left functions?? 4
How to split number and text string to separate cells? 5
Turtle Beach Peripherals 1
Issue with Powerpoint 2010 Video Insert 3
separating out data in columns 2
data splitting 1
Concatenate strings? 4

Top