Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
I'm using the following string as a filter in an Excel plug-in.
('01 - Gen CCT BRKR (Close)' = "Closed" and prevval ('01 - Gen CCT BRKR (Close)') = "Not_Closed")
It helps to count the number of position changes of a power station circuit breaker by spotting when the value 01 - Gen CCTBRKR (Close) goes from Not_Closed to Closed.
But there are 4 of these circuit breakers, 01 to 04. I want to pull the breaker number into the filter from another cell so it can count the position change from any specified breaker.
I've tried to do this using the joining function '&' as well as the Concatenate function, but the extra quotation marks around the Closed and Not_Closed statements cause it to fail in every configuration I've tried. The Closed and Not_Closed statements are the output of another computer system, and are fixed, I can't change them to a binary 1 and 0 which I reckon would fix it.
Can anyone help with a solution? Ta.
Not sure I'm understanding it all but you can use the CHAR() command to put " into a concat statement
That may well help, cheers mikewsmith.
You can also use double-double quotes, e.g.:
=""""&"A"&""""
Displays as
"A"