A Basic Right(Find formula,

[srizki]

Hi all,
I need to extract number from the string as follows,
A B
[TABLE="width: 0"]
<tbody>[TR]
[TD][Sold 411045353]
[/TD]
[TD]45353]
[/TD]
[/TR]
[TR]
[TD][Sold 411045353]
[/TD]
[TD]45353]
[/TD]
[/TR]
[TR]
[TD][Sold 411045353]
[/TD]
[TD]45353]
[/TD]
[/TR]
[TR]
[TD]411044924
[/TD]
[TD]411044924
[/TD]
[/TR]
[TR]
[TD]411044978
[/TD]
[TD]411044978
[/TD]
[/TR]
[TR]
[TD]411044920
[/TD]
[TD]411044920
[/TD]
[/TR]
[TR]
[TD]411045039
[/TD]
[TD]411045039
[/TD]
[/TR]
[TR]
[TD][Sold 411045402]
[/TD]
[TD]45402]
[/TD]
[/TR]
[TR]
[TD][Sold 411045379]
[/TD]
[TD]45379]
[/TD]
[/TR]
[TR]
[TD][Sold 411045397]
[/TD]
[TD]45397]
[/TD]
[/TR]
[TR]
[TD][Sold 411045393]
[/TD]
[TD]45393]
[/TD]
[/TR]
[TR]
[TD][Sold 411045378]
[/TD]
[TD]45378]
[/TD]
[/TR]
[TR]
[TD]411044893
[/TD]
[TD]411044893
[/TD]
[/TR]
[TR]
[TD][Sold 411045388]
[/TD]
[TD]45388]
[/TD]
[/TR]
[TR]
[TD]
I am using this basic formula.
'=IFERROR(RIGHT(C922,FIND
(" ",C922)),C922)
That gives me the result on column B. I want the full number, what I am doing wrong?
Thanks
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about
=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A2," ", REPT(" ",100)),"]",""),100))*1

 

[srizki]

Thank you Fluff.
It is working, but I am trying to understand/learn what is going on there in the formula.

 

[Eric W]

Try:

=IFERROR(SUBSTITUTE(MID(A1,FIND(" ",A1),99),"]",""),A1)

Use MID instead of RIGHT.

 

[Fluff]

Thank yo Fluff

You're welcome & thanks for the feedback

 

[srizki]

Thank you Eric, really appreciated.