Results 1 to 2 of 2

Thread: Help Please custom formating cells

  1. #1
    Neophyte LgoSheeps's Avatar
    Join Date
    Nov 2021
    Posts
    1
    Articles
    0
    Excel Version
    windows 10

    Help Please custom formating cells



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

    Please could someone help me custom format my cells. I have tried copying what is said online and don't seem to be able to get it to work.

    My Data is coming in as UK123456712345 when I import it from the reader (CSV FILE).

    and I would like to have it looking like UK1234567 12345

    Is there a way to custom format the cells to do this I have 1000s of lines of data and it will take forever to get through doing it manually.

    TIA

    Lou

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,023
    Articles
    0
    Excel Version
    365
    It probably best to alter how the data is imported from the csv file.
    How are you currently doing it?
    What version of Excel are you using?
    What decides where to split UK123456712345
    Could you attach a csv file here (you may have to zip it first)?

Posting Permissions

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