Thread: Import text doc to XL. Need items seperated by " " in new column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
irvine79 irvine79 is offline
external usenet poster
  
Posts: 21
Default Import text doc to XL. Need items seperated by " " in new column
Hello,
I am wondering if there is a way to take a text line "0.29 I IF IGI 1238"
and seperate it into columns based on where the space " " occurs?

Column A - 0.29
Column B - I
Column C - IF
Column D - IGI
Column E - 1238

Thanks
Reply With QuoteReply With Quote