Remove Numbers from Cell with Text

[borski88]

I know this question gets asked a lot, but I haven't seen any answers that match the issue I am having.

I have a string of characters that has numbers and letters in locations.
The location of the letters within the string is not in a consistent location I need to extract only the letter.

Here is an example:

0D10

3A92

0B90

F100

D173

B111

5E61

6A90

E262

B311

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

Any help is greatly appreciated.

 

[Rick Rothstein]

I have a string of characters that has numbers and letters in locations.
The location of the letters within the string is not in a consistent location I need to extract only the letter.

Here is an example:

0D10

3A92

0B90

F100

D173

B111

5E61

6A90

E262

B311

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

Your question is not clear... when you say "extract", do you mean from the cell directly so that the remaining letter appear in the original cell, or do you mean you want to put the extracted letters in the cell next to the original cell?

 

[borski88]

I would like the extracted letters in the adjacent cell.

 

[Rick Rothstein]

You could use this formula...

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,""),1,""),2,""),3,""),4,""),5,""),6,""),7,""),8,""),9,"")

 

[borski88]

Works great, thank you!

 

[István Hirsch]

If the given sample is representative (1 letter , 3 digits), you can give this a try too:

=MID(A1,MATCH(TRUE,MID(A1,{1,2,3,4},1)>="A",0),1)