extracting substring

[Rajesh]

Hi,

Please find the follwoing data
abcd efg [R51K]
abc efg[R52E]
abcd efghij [R31K]

From this i need the data without [Rxxx].

please suggest how to do this
Thanks

 

[Jacob Skaria]

Try

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

OR

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

 

[Jacob Skaria]

Another way using REPLACE()

=REPLACE(A1,FIND("[",A1),99,)

 

[Rajesh]

Thank you so much Jacob. it works...

Try

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

OR

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

--
Jacob

Hi,

Please find the follwoing data
abcd efg [R51K]
abc efg[R52E]
abcd efghij [R31K]

From this i need the data without [Rxxx].

please suggest how to do this
Thanks