extracting substring

Rajesh · Jan 7, 2010

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 · Jan 7, 2010

Try

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

OR

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

Jacob Skaria · Jan 7, 2010

Another way using REPLACE()

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

Rajesh · Jan 7, 2010

Thank you so much Jacob. it works...

Jacob Skaria said:
Try

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

OR

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

--
Jacob

Rajesh said:

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

Click to expand...