Thread: Help With Manipulating Data
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Help With Manipulating Data
another way:

State: =LEFT(A1,2)
Position: =MID(A1,FIND(" - ",A1)+3,LEN(A1)-FIND(" - ",A1)-3-FIND(" /
",A1)-4)
Facility: =MID(A1,FIND(" / ",A1)+3,LEN(A1)-FIND(" / ",A1)-2)

HIH
Reply With QuoteReply With Quote