Hi, I have a spreadsheet with many rows of data containing a combination of
letters and numbers. I would like to be able to use formulas to separate the
text from the numbers and end up with the letters in one cell and the numbers
in another, so that the following:

AB1
A20
TMH255

Would become:

AB 1
A 20
TMH 255

Thank you in advance for any help.