Extracting data from between brackets in a cell

[Gooford]

Hi,

I have a list of invoices with a "notes" column.

The notes field may contain random notes but with bracketed numbers contained somewhere, e.g.

Cell A1 =
"abcde (1234) asdf2274"

Can I write a formula in B1 which will extract only the 1234 between the brackets?

Thanks

Matt

[Pete_UK]

Try this:

Please Login or Register  to view this content.

This will be a text representation of the number, so if you want a proper numeric value you should multiply the formula by 1:

Please Login or Register  to view this content.

Hope this helps.

Pete

[zbor]

Try

Please Login or Register  to view this content.

[Gooford]

Thanks both - both work perfectly

Really helpful

Ta

[JustinCC.]

Zbor's solution worked perfectly for my needs. Thanks!