Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 B1123, in C1 A, in D1 B , and in E1 C. how |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 B1123, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract all letters from a cell sentence | Excel Worksheet Functions | |||
how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
Extract letters from a cell | Excel Worksheet Functions | |||
Extract bold letters in a cell | Excel Worksheet Functions | |||
Extract bold letters in a cell | Excel Worksheet Functions |