ExcelBanter - extracting substring

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - extracting substring (https://www.excelbanter.com/excel-discussion-misc-queries/252667-extracting-substring.html)

Rajesh

extracting substring

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

extracting substring

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

Jacob Skaria

extracting substring

Another way using REPLACE()

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

--
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

Rajesh

extracting substring

Thank you so much Jacob. it works...

"Jacob Skaria" wrote:

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

All times are GMT +1. The time now is 01:12 PM.