+ Reply to Thread
Results 1 to 2 of 2

formula to split data in respective columns

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

    formula to split data in respective columns

    How to split text from numbers

    I have a range a range of data in which the first digit starts with 8 characters (using left A2,8 for numbers) but how to extract to have results in header 3
    Attached Files Attached Files
    Last edited by JEAN1972; 02-06-2017 at 02:19 PM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: formula to split data in respective columns

    If you are using
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    why not use also
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

+ 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] formula for data to be split to specific columns
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-18-2017, 03:50 PM
  2. [SOLVED] formula to split data to their respective columns
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-16-2016, 11:50 AM
  3. [SOLVED] Formula for automatically multiply two respective cells in columns and then sum up
    By dino4u86 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-21-2015, 02:27 AM
  4. Formula to Split Data between two columns
    By sx200n in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-19-2015, 06:50 AM
  5. [SOLVED] Formula required to split uneven data into different columns
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-14-2015, 04:25 AM
  6. Replies: 2
    Last Post: 07-17-2014, 03:45 AM
  7. Inserting the data in to respective columns
    By sathishkm in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 10-11-2013, 03:53 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