I have a variable length string.
The beginning of the string begins with text followed by a colon.
I tried to parse this in excel. I exported into an excel spreadsheet, but it converts the sparsed text into a date. Not a text string.
Beginning of the string is as follows with the : as a delimiter, for example:
1-60:
12-60:
The string ends with the text SEC as a delimiter:
SEC 14
SEC 1
SEC 22
How can I parse the beginning and end of my text field with : as a beginning delimiter and SEC as an ending delimiter?
Thank you.
HEFLY
The beginning of the string begins with text followed by a colon.
I tried to parse this in excel. I exported into an excel spreadsheet, but it converts the sparsed text into a date. Not a text string.
Beginning of the string is as follows with the : as a delimiter, for example:
1-60:
12-60:
The string ends with the text SEC as a delimiter:
SEC 14
SEC 1
SEC 22
How can I parse the beginning and end of my text field with : as a beginning delimiter and SEC as an ending delimiter?
Thank you.
HEFLY