Excel formula to extract words before a match

[satish78]

Hi Friends,

Here is the data and what I am trying to extract
I want to extract words like Hexadecimal to character" which is abbreviated as X2C
I am able to extract text between characters "(" AND ")" but not full meaning/form of abbreviated word.

Hexadecimal to character (X2C) is a conversion o
Hexadecimal to decimal (X2D) is a conversion
Explainable artificial intelligence (XAI) is a key term in AI design
Transaction Authority Markup Language (XAML) is an XML-based, ve

I need data like this
ColumnC ColumnD
X2C Hexadecimal to character
X2D Hexadecimal to decimal
XAI Explainable artificial intelligence
XAML Transaction authority Markup Language

Hope you got the point what I am looking to extract into columns.

 

[Tim_Excel_]

=MID(A1, FIND("(", A1)+1, FIND(")", A1)- FIND("(", A1)-1)

Returns abbreviation

=LEFT(A1,FIND(" (",A1)-1)

Returns description

 

[satish78]

=MID(A1, FIND("(", A1)+1, FIND(")", A1)- FIND("(", A1)-1)

Returns abbreviation

=LEFT(A1,FIND(" (",A1)-1)

Returns description

above formulas are not getting results.

 

[Tim_Excel_]

They should, as I have tested them on the data you provided.

Are you sure you are referring to the correct cell address?