I saw an answer to a query posted earlier which is almost the same as a problem I have.
I have text in a cell that looks as follows: The rows go down about 1000 rows.
ABCD_YZ1234_123456789
_ is a space.
After the second space there will always be 9 digits.
I want to be able to strip those last 9 digits and the second space out of the string leaving only the remaining text to the left.
The mid section e.g. YZ1234 could be variable up to a between 3 and 6 characters. This means i can not just use LEFT(A1,9) as I will not always get the variable mid section.
the spaces will always be the same.
A previous post offered
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))
This I have been tweaking to try to sort my problem but I can't quite nail it.
Any ideas?
Thanks in advance
I have text in a cell that looks as follows: The rows go down about 1000 rows.
ABCD_YZ1234_123456789
_ is a space.
After the second space there will always be 9 digits.
I want to be able to strip those last 9 digits and the second space out of the string leaving only the remaining text to the left.
The mid section e.g. YZ1234 could be variable up to a between 3 and 6 characters. This means i can not just use LEFT(A1,9) as I will not always get the variable mid section.
the spaces will always be the same.
A previous post offered
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))
This I have been tweaking to try to sort my problem but I can't quite nail it.
Any ideas?
Thanks in advance