Results 1 to 2 of 2

Thread: Pull Data Formula

  1. #1
    Neophyte KhodrK1590's Avatar
    Join Date
    Oct 2021
    Posts
    4
    Articles
    0
    Excel Version
    2021

    Pull Data Formula



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

    Hello,

    I have a column with cost center numbers that are like this:

    76701000VT91549009


    I want to make a new column where I pull only the last TEN numbers of the column, let's say COLUMN H is those numbers, and COLUMN I is where I want
    VT91549009

    What would be the formula to do this?

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,720
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    Say your first cell containing data is A1, use this in B1 copied down:

    =RIGHT(A1,10)
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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