tab cells and relocating ?

[Matkalg]

can i tab tight words into new cells ie:
lovereallyhurtswithoutyoubillyocean
(cell 1) should be love really hurts without you - (cell 2)billy ocean

when i removed the spaces from the front and back of my cell with this formula : =TRIM(PROPER(C1)) i cant change the text in the cell anymore can i now change it to a text i can edit...
thanks again

 

[Oaktree]

To remove the numbers, try:

=RIGHT(A1,LEN(A1)-SEARCH(" ",A1))

You cannot automatically "tab tight words into new cells".

 

[Matkalg]

thanks oaktree but i have a new one now... see first text box