srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,844
- Office Version
- 365
- Platform
- Windows
Hi all,
I need to extract number from the string as follows,
A B
<tbody>
</tbody>
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>