Page 2 of 2 FirstFirst 1 2
Results 11 to 13 of 13

Thread: Consolidating based on first three characters and counting

  1. #11
    Acolyte Kevin@Radstock's Avatar
    Join Date
    Oct 2012
    Posts
    52
    Articles
    0
    Excel Version
    365


    Register for a FREE account, and/
    or Log in to avoid these ads!

    yoshimura

    What result would you return if you had a post code: BA14 5TT!

    Quote Originally Posted by yoshimura View Post
    Hey guys,

    I just used the LEFT function and it works… except that I need it to start referencing from a cell and then down the whole column.

    An example that is giving me an error:

    =LEFT(C3:C,3)

  2. #12
    Hello Kevin,

    The result would be BA1. Is there something particular that you're trying to figure out, or?

    I used the INDEX function to meet my need for this. My next issue is in this thread (I also uploaded the Excel files).

  3. #13
    Acolyte Kevin@Radstock's Avatar
    Join Date
    Oct 2012
    Posts
    52
    Articles
    0
    Excel Version
    365
    No Mate

    I give up!

Page 2 of 2 FirstFirst 1 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •