1. Contracting
    1. General
      1. Brexit
    2. Business / Contracts
      1. Coronavirus Assistance
    3. Accounting / Legal
      1. Umbrella Companies
      2. HMRC Scheme Enquiries
      3. The Future of Contracting
      4. IR35 Reform
    4. Technical
    5. Welcome / FAQs
  2. Social
    1. Light Relief
    2. Social / Events
  • Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel problem

Collapse
X
11 to 13 of 13 Previous 1 2 template Next
Collapse
Reply to Thread
  •  
  • Filter
  • Time
  • Show
Clear All
new posts
11 to 13 of 13 Previous 1 2 template Next
    #11
    Thanks all for the help. Job done and newsletter (spam ), on the way.
    Me, me, me...

    Comment

      #12
      Bit late but this formula would have helped:

      Code:
      =IF(LEN(A1)-IFERROR(FIND(".co.uk",A1),0)=5, ".co.uk","")
      Coffee's for closers

      Comment

        #13
        real men use AWK!
        Always forgive your enemies; nothing annoys them so much.

        Comment

        Reply to Thread
        11 to 13 of 13 Previous 1 2 template Next

        Advertisers

        1. Contracting
          1. General
            1. Brexit
          2. Business / Contracts
            1. Coronavirus Assistance
          3. Accounting / Legal
            1. Umbrella Companies
            2. HMRC Scheme Enquiries
            3. The Future of Contracting
            4. IR35 Reform
          4. Technical
          5. Welcome / FAQs
        2. Social
          1. Light Relief
          2. Social / Events
        Working...
        X