+ Reply to Thread
Results 1 to 5 of 5

Extract 3 descimal numbers into separate columns

  1. #1
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Extract 3 descimal numbers into separate columns

    In the file below I am trying to extract the three decimal numbers in columns B2, C2, and D2
    Raw Goods - Supplies 3.20 3.80 1.95


    https://docs.google.com/spreadsheets...it?usp=sharing

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: Extract 3 descimal numbers into separate columns

    As external links are notoriously unsafe, please post you sheet on the board ( see yellow banner). Thanks

  3. #3
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,147

    Re: Extract 3 descimal numbers into separate columns

    Try this;

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    08-21-2010
    Location
    Bournemouth, England
    MS-Off Ver
    Microsoft 365
    Posts
    215

    Re: Extract 3 descimal numbers into separate columns

    That works perfectly. Thank you very much.

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,858

    Re: Extract 3 descimal numbers into separate columns

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract Sequential Numbers of 5 or More Into Separate Columns
    By etm6477 in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 11-13-2019, 01:25 PM
  2. [SOLVED] Formula to separate joined numbers in one column into two columns or two separate cells
    By Doofus1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-28-2019, 05:23 PM
  3. How to Extract Street Numbers from an Address to Separate Columns
    By SeaTiger in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-05-2017, 12:15 PM
  4. [SOLVED] Separate input numbers into separate columns.
    By Tona in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2015, 04:23 AM
  5. [SOLVED] Extract and separate the letters into their own separate columns
    By siroos12 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-22-2013, 10:18 AM
  6. [SOLVED] 2 separate columns with numbers separated by commas and single numbers not, need sum
    By Slothbob in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2013, 04:33 PM
  7. Extract Numbers From RandLotto List Into Separate Cells
    By chelseasikoebs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2009, 09:18 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