View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JohnG1965 JohnG1965 is offline
external usenet poster
 
Posts: 4
Default Converting .txt file to rows

Rick,
Thanks for the response (you too Joel, but Rick's seemed easier). It worked
well except where my text document line ended at DEVELOP Excel imported it as
follows:

N1*PN*INBOUND LOGISTICS*92*92]
"N1*SU*SHAW DEVELOP"
MENT, LLC*92*F5332B0]
(there's actually a little question mark inside a square at the end of
DEVELOP on my worksheet)

This is a ton of help as is, but if you could make it do this it'd be perfect:

N1*PN*INBOUND LOGISTICS*92*92]
N1*SU*SHAW DEVELOPMENT, LLC*92*F5332B0]

Thanks again,