Breaking up a cell

[rudy1]

Hi,

Is there any way to break up a cell? I've used the Concatenate formula to put two cells together but I can't seem to find a way to reverse it.

For example if I have "rudy 1" in a cell, is there a formula/VBA I can use to put "rudy" and "1" into two different cells?

Thank you in advance.

[Charlize]

If first part is always made out of letters, try this

=LEFT(A1;LEN(A1)-VALUE(MID(A1;SEARCH(" ";A1;1);LEN(A1))))
to give rudy, and this
=VALUE(MID(A1;SEARCH(" ";A1;1)+1;LEN(A1))) to get 1

Maybe you have to change the ; to ,

[Bob Phillips]

Menu Data>Text to columns with space as a delimiter