Results 1 to 20 of 20

Extract 2 digits from a 3 digit number in different sequences

Threaded View

  1. #1
    Forum Contributor Brian.Aerojet's Avatar
    Join Date
    03-25-2017
    Location
    TN-USA
    MS-Off Ver
    2016 365
    Posts
    173

    Extract 2 digits from a 3 digit number in different sequences

    Hello Everyone,

    I have a column with 3 digit numbers (A), then I have 3 columns where I pull each of the 3 digit number to show single digits in Columns (B, C, D)

    Next in column "E" I pull the 1st and 2nd digit from the 3 digit numbers in column A and put them together.

    Column F is my problem, I will explain after I explain Column G.

    Column "G" I pull the 2nd and 3rd digit from the 3 digit numbers in Column A and put them together.

    I have both E and G columns working with the formula Im using

    Now for Column F i want to pull the 1st digit and the 3rd digit from the 3 digit number to put in column F together just like columns E and G.

    I can't figure out how to pull the 1st digit and 3rd digit and leave 2nd digit alone for this Column F.

    BTW, these numbers will continue over time and I will need to just drag down the column to update future 3 digit numbers


    Thanks,
    Brian
    Attached Files Attached Files
    Last edited by Brian.Aerojet; 08-23-2018 at 11:00 PM.
    Brian

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 guests)

Similar Threads

  1. Remove 2 digits from a 11 digit number
    By puneetjain in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2018, 03:35 AM
  2. Replies: 5
    Last Post: 06-04-2015, 03:25 PM
  3. [SOLVED] Extract Exact 6 Digit Number From String
    By tt388 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2013, 12:51 PM
  4. How to add 2 digits to the end of a four digit number
    By Gordond54 in forum Excel General
    Replies: 6
    Last Post: 01-01-2013, 04:19 PM
  5. Replies: 4
    Last Post: 09-16-2012, 10:26 AM
  6. Fining the first 2 digits of a 6 digit number
    By adam8090 in forum Excel General
    Replies: 10
    Last Post: 05-18-2011, 10:41 AM
  7. Adding first and last digits of a four digit number in vba
    By CollegeKidd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-13-2011, 06:58 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1