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


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

 

[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.