A Basic Right(Find formula,

[srizki]

Hi all,
I need to extract number from the string as follows,
A B

[Sold 411045353]	45353]
[Sold 411045353]	45353]
[Sold 411045353]	45353]
411044924	411044924
411044978	411044978
411044920	411044920
411045039	411045039
[Sold 411045402]	45402]
[Sold 411045379]	45379]
[Sold 411045397]	45397]
[Sold 411045393]	45393]
[Sold 411045378]	45378]
411044893	411044893
[Sold 411045388]	45388]
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

<tbody>
</tbody>

 

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