View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Narasimha Narasimha is offline
external usenet poster
 
Posts: 23
Default separating alpha numeric vlue

Hi all,
how do separate alpha numeric value for example I have values like
ABC123,AB234
starts with alpha but the length may be 2 or 3 or 4. just I want alpha value
in one column and numeric in another column.

could anyone help me ?
thanks