Cable Forum - View Single Post - Excel Formula

absthechatter · 07-12-2006, 13:11

I have a long list of staff numbers. All are 6 digits followed by a letter.

If the whole staff number is in column A, is it possible to use a formula to put the digits without the letter in one column and the letter on its own in the next column?

Many thanks

Abs

07-12-2006, 13:11	#1
absthechatter cf.addict Join Date: Dec 2004 Posts: 310	Excel Formula - Is this possible? I have a long list of staff numbers. All are 6 digits followed by a letter. If the whole staff number is in column A, is it possible to use a formula to put the digits without the letter in one column and the letter on its own in the next column? Many thanks Abs