AnsweredAssumed Answered

VRF- text string DDE to EXCEL

Question asked by VRFuser on Apr 15, 1999
Latest reply on Apr 15, 1999 by VRFuser
  • Comment • 1
HP VEE - Ver 3.21
PC - NT

I have a text string that I would like to put into an EXCEL spreadsheet, the
string is five 'words' that are seperated by, normally 2 or 3, spaces.
The text string is in the format

1.  +3.50KV  90  +2.75KV  +1.70KA
2.  -3.50KV  90  -2.67KV  -1.69KA
.......etc
.......etc
.......etc
10. -3.50KV  90  -2.67KV  -1.69KA

because the spaces are not always at the same location in the string, I
can't just look for characters x to n.

I would like each word to be in a seperate column


John McBain
Product Compliance Engineer
Swichtec Power Systems Ltd
39 Princess St          Ph:  (++64) 3 343 7440 ext 8498
PO Box 11-188     Fax:(++64) 3 343 5100
Christchurch          E-Mail: jmcbain@swichtec.co.nz
NEW ZEALAND

visit us at http:\www.swichtec.co.nz


No one else has this question

Outcomes