extracting letters/numbers from a cell

[jkreizman]

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

	The required numbers from cell A1 into B1 are "364" (note - without using =righ(x,x) function):
	A B 1 WHCND27364 364 <tbody> </tbody>

<tbody>
</tbody>

 

[jkreizman]

Clarification: more precisely, trying to remove values rather than extracting them.

Thanks.

 

[gaz_chops]

Welcome to the forum.

Provide some more examples. Is it always required that you remove the 1st 7 characters?

 

[jkreizman]

thanks gaz.

Exactly, same amount of characters to be removed each time.

 

[gaz_chops]

Try

=REPLACE(A1,1,7,"")

 

[jkreizman]

Try

=REPLACE(A1,1,7,"")

---------------

Works great. Thank you very much!!!

 

[gaz_chops]

You're welcome.