Solved Tip for EXCEL users - extract text between parentheses

Hi folks
Some people might find this little snippet good.

While trying to build a Historical data set of stocks in various indices one needs the share code. Often you get the title with the share code in between a set of ()'s. So It's simple to extract = but not intuitive.

Use this formula =MID(A2,FIND("(",A2)+1,FIND(")",A2)-FIND("(",A2)-1)

where the text is in say CELL A2 - and then propagate down the entire column -- Have a look at the J column.

e,g




Hope this is of interest to some -- There are a load of EXCEL users but using these lesser known functions can often save a load of extra work.

STOCK data / HISTORY doesn't work on non OFFICE/365 versions even OFFICE 2021 LTSC. If you attempt to use it you get the message "BLOCKED - LICENSE required (OFFICE/365). However with EXCEL there are always "Alternate" ways of "replicating" newer functionality !!!!

Cheers
jimbo

kelper said:

So, what happened in cell J3?

Click to expand...

I think that was just "Snipping tool" getting its knickers in a twist - J3 is fine



cheers
jimbo

I deleted my silly post just before you replied. How long did it take you to perfect quite a complex formula?
Have you tried with the SUBSTITUTE command? There are lots of solutions on the internet for removing parentheses.

I like to use the IF command in my spreadsheets so rows with data not yet added don't spawn lots of gibberish.

I am tracking my monthly electricity meter readings. All the formulae are entered down to row 100.
But as I have yet to enter a meter reading in B63 the cells to the right show nothing.

kelper said:

I deleted my silly post just before you replied. How long did it take you to perfect quite a complex formula?
Have you tried with the SUBSTITUTE command? There are lots of solutions on the internet for removing parentheses.

I like to use the IF command in my spreadsheets so rows with data not yet added don't spawn lots of gibberish.

I am tracking my monthly electricity meter readings. All the formulae are entered down to row 100.
But as I have yet to enter a meter reading in B63 the cells to the right show nothing.


View attachment 72900

Click to expand...

Now if those people telling users to have smart meters installed would supply this data in a downloadable CSV etc format - wouldn't that be a decent service if users could access the data on those and get this data directly - but I suspect the last time any large organisation even THOUGHT about any tiny smidgen of customer service was perhaps at the time Queen Victoria was on the throne holding sway over the British Empire !!!!.


Cheers
jimbo