Kez

@kez

active 3 months, 2 weeks ago
  • Kez posted a new activity comment 3 months, 2 weeks ago

    Have you tried just using “&” it’s a bit of a long shot but it might still be there as in (A2)&(B6) is concatenate, but in shorthand.

    • I’ve got a number of cells with text that I want to concatenate with a delimiter but excluding blank cells. Textjoin does the job with no need for extra logic.

      Eg; an address over several cells converted to a single string with commas.

      Concatenate function is still available.

  • Kez posted a new activity comment 4 months ago

    “I see no reason to pay any money to the EU, except for an administration fee, and have no wish to fund the development of other EU countries. Either all countries pay or none at all. And yes I know the argument that helping other countries develop increases their ability to buy things from us.”

    How much do you think it’s going to cost to employ…[Read more]

    • isac replied 4 months ago

      My objection to paying the EU money is based on fairness.

      Either all countries pay or none do.

      But that of course wouldn’t allow the EU to finance its social programme would it?

      UK law is subsidiary to ECJ law because we signed up to it which was a mistake.

      We’ve had years of uncontrolled immigration from EU countries again because we signed…[Read more]

  • Kez posted a new activity comment 5 months, 1 week ago

    I was recently thinking of getting one as I buy a lot of fizzy water. But they are so expensive and you have to buy their gas refills. Sort of went off the idea.

  • Kez posted a new activity comment 5 months, 2 weeks ago

    S6 edge user here. Really like the phone, and the camera is excellent. The display on the edge is very nice, but I wouldn’t pay extra for it (the phone shop sold my S6 by mistake and gave me the edge for the same price).

    My old S2 has only just given up the ghost, and that was a great phone. Like the sound of the S4 active though.

  • Kez posted a new activity comment 5 months, 2 weeks ago

    That’s like me! I bought a derelict Victorian house and did it up. I’d never have been able to afford it if it had been in England. I love it to bits but I still feel sometimes like I’m here under false pretences and one day someone is going to find me out