Thread: separate string into letters and numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aileen aileen is offline
external usenet poster
  
Posts: 78
Default separate string into letters and numbers
I have strings of data as such:
SYG0919L625
SPZ1020X1025
DO0919M25.5

I need to separate these strings into 4 columns delimited by number and
letter. e.g.
The data should look as such:

Col 1 Col 2 Col 3 Col 4
SYG 0919 L 625
SPZ 1020 X 1025
DO 0919 M 25.5

Any ideas?
Reply With QuoteReply With Quote