Thread: remove English letter in cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wu Wu is offline
external usenet poster
  
Posts: 36
Default remove English letter in cells
I have the data in different cells contain number and English letter,

For example:

1209N
WS123
B10-0909C
0908M


Result:

1209
123
10-0909
0908

How can I just remove the English letter in these cells?

Reply With QuoteReply With Quote