+ Reply to Thread
Results 1 to 2 of 2

Formula to Split Data between two columns

  1. #1
    Registered User
    Join Date
    09-17-2014
    Location
    Cambridge, England
    MS-Off Ver
    2016
    Posts
    58

    Formula to Split Data between two columns

    Morning,

    I hope you can help. I have a large spreadsheet which will contain (for example) Column A that has a long list of Make and Models of vehicles in this format:

    Ford Focus 1.6 Ghia LX

    Now I really need to make a split so that Just the Make is displayed in Column B and then the rest of the data in Column A is moved into Column C as the model of the vehicle.

    Given that the Make of the vehicles will very in length, can anyone think of a formula that might suit?

    Kind Regards

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,695

    Re: Formula to Split Data between two columns

    So you mean Ford Focus goes into column B and the rest into C? Will it always be the first two words?

    Pete

+ 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 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
  2. Split data into columns
    By SonDur in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-18-2014, 04:12 PM
  3. [SOLVED] Split Data in Columns
    By naveenmarapaka in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2013, 06:54 AM
  4. Split uneven data from a single columns to multiple columns
    By pfoz in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-13-2013, 08:24 AM
  5. Data split in 2-3 columns
    By mohan.r1980 in forum Excel General
    Replies: 6
    Last Post: 04-14-2012, 09:45 AM

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