View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith S[_2_] Keith S[_2_] is offline
external usenet poster
 
Posts: 2
Default Seperate letters and numbers in a cell

I have a spreadsheet where one column has cells with letters and numbers. I
want to seperate the letters into one cell and the numbers into another cell.
For example:

Cell Prefix Suffix
abcd041 abcd 041
qjwxkl678 qjwxkl 678
abc1455 abc 1455

Thanks for any help on this.