B
Brian Ashcraft
Hello All,
Thanks in advance for you help!!
I am trying to extract data from a single cell in Excel.
Example Data:
MX04-08-1-EA
MX04-1000-100-EA
MX04-10-10000-50-EA
The data I want to extract is the data "to the left" of the "second
dash from the right".
Example Data, With Results:
MX04-08-1-EA MX04-08
MX04-1000-100-EA MX04-1000
MX04-10-10000-50-EA MX04-10-1000
MX-04-999-G7-1-EA MX-04-999-G7
My starting data can have two or more dashes in it, but will always
have a minimum of two.
For reasons which I will not go in to, I am unable to write vbScript
functions in this spreadsheet. I need to use the MID, LEN, FIND, etc
to accomplish this.
ANY help is much apprecaited....
Thanks in advance for you help!!
I am trying to extract data from a single cell in Excel.
Example Data:
MX04-08-1-EA
MX04-1000-100-EA
MX04-10-10000-50-EA
The data I want to extract is the data "to the left" of the "second
dash from the right".
Example Data, With Results:
MX04-08-1-EA MX04-08
MX04-1000-100-EA MX04-1000
MX04-10-10000-50-EA MX04-10-1000
MX-04-999-G7-1-EA MX-04-999-G7
My starting data can have two or more dashes in it, but will always
have a minimum of two.
For reasons which I will not go in to, I am unable to write vbScript
functions in this spreadsheet. I need to use the MID, LEN, FIND, etc
to accomplish this.
ANY help is much apprecaited....