+ Reply to Thread
Results 1 to 6 of 6

split numbers to to specific columns headers

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,079

    split numbers to to specific columns headers

    I have a worksheet with a column A where numerical and text are mixed, the numbers represents tax rate .

    the worksheet has been condensed for ease of understanding as it represents data of 12000 rows .

    formula to split numerical data only to their respective tax column headers COLUMN B, C and D
    Attached Files Attached Files
    Last edited by JEAN1972; 01-14-2018 at 08:48 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: split numbers to to specific columns headers

    What does the data that you want to split look like? You only seem to have included what you want it to look like.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,079

    Re: split numbers to to specific columns headers

    The data to split is column A and output results on B,C and D (yellow)

    That is numeric with more than 1 figures column B,with 1 figures column C and columns D figures with cents converted to 0.03 instead of 3
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: split numbers to to specific columns headers

    VBA, if you like
    Try
    Please Login or Register  to view this content.
    Last edited by jindon; 01-14-2018 at 10:18 AM. Reason: Fixed a typo. was Long...

  5. #5
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,079

    Re: split numbers to to specific columns headers

    Thank you Jindon works perfectly

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: split numbers to to specific columns headers

    You are welcome and thanks for the rep.

    You may still receive formula solution though. (not from me for sure)

+ 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. [SOLVED] vba to split numbers and text to their headers from a merge cell column
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-22-2017, 09:40 AM
  2. [SOLVED] vba code to merge headers from 2 sheets at their specific columns position 3rd sheet
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2017, 11:41 PM
  3. [SOLVED] formula for multiple split headers of text and numbers to respective headers
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-19-2017, 10:17 AM
  4. How to split numbers to specific name and total and split
    By ashokavarthanan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2015, 09:12 AM
  5. [SOLVED] Delete columns - Prioritise columns with specific headers
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2015, 07:18 AM
  6. Copy data under specific columns in sheet1 n paste to sheet2 under the same headers
    By ShyamEXcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2012, 02:15 PM
  7. VBA look for the average for each row with columns with specific headers.
    By dimer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-08-2011, 12:31 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