Modify a "Split" statement

I had help in the past from this forum to make a split statement

Please Login or Register  to view this content.

The above takes a cell with data like this:
"TA(#31," and splits it like this:
"31"

Now I have another unique split. Using the same example above but modifying the cell data.
"TA({#31," and splits it like this: (Added a "{" )
"{31}" (adding an ending "}" )

Any hints, tips or examples are appreciated.

Hello Rick,

Here is one way using Regular Expressions. If the number is found between the (# and ), it is returned. Otherwise the cell value is returned unchanged.

Extract Number Macro

Please Login or Register  to view this content.

I believe I understand what your function does but I do not think it will output what I need.
Here is the macro.

Please Login or Register  to view this content.

sBubbleNumber is being compared to the value of all cells in Column A for a match, if sBubbleNumber and a cell in column A match then another cell (far right, offset 16 and or 17 cells from A) is populated.

My mission (haha) is to modify my search from the original code of these two lines:

Please Login or Register  to view this content.

To something like this?

Please Login or Register  to view this content.

Added opening bracket "{".
sBubbleNumber would have to be formatted as "{XX}" where XX is a numeric value.

Looking at this, I think I can do a "Replace" for the "#" with "{" and then add a closing bracket "}"?

Hello Rick,

Perhaps I misunderstood your post. You are not looking to extract the number from the string "TA({#31" as 31 but as (31)?

Hello Rick,

This version will extract the number and add the braces to around it. If not it will return the original value.

Please Login or Register  to view this content.

You would call it like this ...

Please Login or Register  to view this content.

Originally Posted by Leith Ross

Hello Rick,

Perhaps I misunderstood your post. You are not looking to extract the number from the string "TA({#31" as 31 but as (31)?

The number with opening and closing brackets.
As {31} (the squiggly brackets, I just can not remember what they are called)

Hello Rick,

In my last post, I did not have the pound sign in the expression. The code below will place the braces around the number.

Please Login or Register  to view this content.

Thank you Leith, as always your solutions use far less code than mine LOL