Try

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

OR

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

--
Jacob


"Rajesh" wrote:

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