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