rudy1
08-02-2007, 02:20 PM
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.
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.