Parse Data from Cell

[rpaonline7]

Looking for help in extracting data from a cell:

1234567890: Doe, John (jdoe)

Specifically, I am looking to extract the text within the brackets. In this example, the result would be jdoe.

I also included a sample file which includes the raw data and expected results. Thanks in advance.

[jeffreybrown]

Try in B2 copied down

=MID(A2,SEARCH("(",A2)+1,SEARCH(")",A2)-SEARCH("(",A2)-1)

[rpaonline7]

That worked. Thank so much for the quick response.

[MarvinP]

Hi rpaonline,

This method replaces those "(" and ")" with 100 spaces, then Mid() and Trim.
There are a few other ways but I like this one.

Please Login or Register  to view this content.

Parse using spaces then Trim.xlsx

[jeffreybrown]

You are very welcome and thank you for the feedback/rep.