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,
|