A manual way to do this is to use the Text to Columns command in the Data
Menu.

Work on a backup to get used to the method.

Select the single column range with the text you wish to change.
Data\Text to Columns
Fixed Width, Next
Create a line at the break point you need, Next
For Column 1
Skip
For Column 2
General
You can select a different destination, The default is to overwrite.
Finish.

This should leave you with the Data modifed as required and no additional
formulae

hth RES