View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ghost ghost is offline
external usenet poster
 
Posts: 41
Default 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