How to Identify Number within text and show number as final result.

Ronak321

Hi All,

Can Someone help as to how can we Identify number within a Text Formatted Line item and move those numbers to a new line item with number as a format using some formula.

 

E.g.

Line item 1: Text Format :  VV123BO

Line Item 2: Number Format :  123    ( the line item 2 should automatically identify number in Line item 1 and bring it in line item 2)

 

 

Regards,

Ronak

Ronak321

@ Misbah ,
The data is totally unstructured where Length of characters within the text is not fixed.
Previously I had used MID function to arrive at final result where data length was fixed and it was working.

 

Is there any other way, where irrespective of Data length and number of characters , the formula just identify number in between the text and gives us the final result with those numbers

ALKA

Thanks @ChrisAHeathcote , worked!

 

@Ronak321 , you should mark his solution as solved 🙂