Forum Discussion

Steve-TESTRITE's avatar
Steve-TESTRITE
Copper Contributor
Nov 18, 2024

formula to extract number value before a specific criteria

Hello, I'm trying to extract first batch of numbers from the string below so it'll be 300, can anyone help? A formula to call out number value before text value "Wh" Jackery 300w portable po...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Nov 19, 2024
=VALUE( TAKE( TEXTSPLIT( TEXTBEFORE( A1, "Wh " ), " " ),, -1 ) )

 

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Nov 19, 2024

    Nice solution. Shorter and simpler.

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Nov 30, 2024

      One way or another that doesn't seem to matter Steve-TESTRITE 

Resources