Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split column on first space | Excel Discussion (Misc queries) | |||
Text to columns, split at first space only | New Users to Excel | |||
Split field based on number of characters and space | Excel Worksheet Functions | |||
Split text without using data-text to columns | Excel Discussion (Misc queries) | |||
text cells end page how split to next. Text lost! | Excel Discussion (Misc queries) |