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

Options
Ronak321
Ronak321 Member, ALL USERS Posts: 2 New Contributor
in Planning & Modeling

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

Tagged:

Comments

  • Ronak321
    Ronak321 Member, ALL USERS Posts: 2 New Contributor

    @ 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
    ALKA Member, ALL USERS, Partner Posts: 5 Occasional Contributor

    Thanks @ChrisAHeathcote , worked!

     

    @Ronak321 , you should mark his solution as solved 🙂

Categories