Formula to extract the number or numbers before a character

[Pasadu]

Sir, Please I want a formula where i could extract the number or numbers before the character "X" in a cell.
My Excel version is Microsoft Office Professional Plus 2016


Thank You.

 

[Gargamelbarbosa]

Hi
If your version office 365 insider , you can use TEXTBEFORE function.
or
E16 >>> =LEFT(D16,search("x",D16)-1) copy formula down

 

[Pasadu]

Hi
If your version office 365 insider , you can use TEXTBEFORE function.
or
E16 >>> =LEFT(D16,search("x",D16)-1) copy formula down

Thank you, I used the left and search functions

 

[AlanSidman]

An alternative is with Power Query which is found on the Data Tab and called Get and Transform Data

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Inserted Text Before Delimiter" = Table.AddColumn(Source, "Text Before Delimiter", each Text.BeforeDelimiter([PRODUCT], "X"), type text)
in
    #"Inserted Text Before Delimiter"