Hi,
I'm trying to figure out a way to extract a certain number of letters/numbers from a partucilar cell.
For instance if I have the following line:
WHCND27364
I want to remove "WHCND27" and remain only with "364", but without using the =Right(X,3) function.
Is there a way to obtain this?
Many thanks!
Jonathan
<tbody>
</tbody>
I'm trying to figure out a way to extract a certain number of letters/numbers from a partucilar cell.
For instance if I have the following line:
WHCND27364
I want to remove "WHCND27" and remain only with "364", but without using the =Right(X,3) function.
Is there a way to obtain this?
Many thanks!
Jonathan
The required numbers from cell A1 into B1 are "364" (note - without using =righ(x,x) function): | ||||||||||||
<tbody> </tbody> |
<tbody>
</tbody>