A
ah
Hi;
Can anyone advice me on how to :
extract all the wording in a cell except the numeric value, for example:
Example:
For ABCDDEFG 1234-------> I want it to appear as ABCDEFG for me only.
For ABC198765-------------> I want it to appear as ABC for me only
Previously I'm using the left function as follows:
=LEFT(INDIRECT("Sheet1!A"&ROW()),8)
However, for the above formula to work, I need to know the exact number of
characters that I'm going to extract. Please advice whether there is any
other alternative solution for this. For your information, the numeric value
will always be placed at the back.
Can anyone advice me on how to :
extract all the wording in a cell except the numeric value, for example:
Example:
For ABCDDEFG 1234-------> I want it to appear as ABCDEFG for me only.
For ABC198765-------------> I want it to appear as ABC for me only
Previously I'm using the left function as follows:
=LEFT(INDIRECT("Sheet1!A"&ROW()),8)
However, for the above formula to work, I need to know the exact number of
characters that I'm going to extract. Please advice whether there is any
other alternative solution for this. For your information, the numeric value
will always be placed at the back.