How to extract numbers from letters in cell?
 

Hi,

If I have a cell that contains numeric & alpha data. For example: ABC123 in
cell A1 what I want to do is, in B1€�123€�, in C1 €œA€�, in D1 €œB€� , and in E1
€œC€�. how

How to extract numbers from letters in cell?
 

In cells A1 thru E1 enter:
abc123
=RIGHT(A1,3)
=LEFT(A1,1)
=MID(A1,2,1)
=MID(A1,3,1)

--
Gary''s Student - gsnu200798

How to extract numbers from letters in cell?
 

On Wed, 6 Aug 2008 03:33:03 -0700, ghost
wrote:

Hi,

If I have a cell that contains numeric & alpha data. For example: ABC123 in
cell A1 what I want to do is, in B1”123”, in C1 “A”, in D1 “B” , and in E1
“C”. how

B1:

=LOOKUP(9.9E+307,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},
A1&"0123456789")),ROW(INDIRECT("1:"&LEN(A1)))))

C1: =MID(SUBSTITUTE($A$1,$B$1,""),COLUMNS($A:A),1)

Fill C1 right to E1 (or as far as required to include all the letters)

--ron