+ Reply to Thread
Results 1 to 4 of 4

How to split cells into 3 different cells

  1. #1
    Registered User
    Join Date
    04-20-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    77

    How to split cells into 3 different cells

    Hello Everyone,

    I am importing text file in Excel, but all data is importing in a column I want to split a column data into 3 different cells. How can I do it please suggest.

    Thanks in Advance

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,878

    Re: How to split cells into 3 different cells

    How does you data look like? Please attach a sample workbook
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    04-20-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    77

    Re: How to split cells into 3 different cells

    Hi,

    Sorry to delay in reply, please find the attached data.

    Thanks
    Ankit
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: How to split cells into 3 different cells

    Try this. It does work for your examples...
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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] Split column of cells, each cells data is separated by commas into separate rows
    By mike_m1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-09-2014, 08:33 AM
  2. Split cells
    By mkinzly in forum Excel General
    Replies: 6
    Last Post: 07-03-2010, 02:05 PM
  3. Replies: 1
    Last Post: 02-11-2006, 01:00 PM
  4. [SOLVED] split cells
    By mwuttke in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 03:05 PM
  5. Split Cells
    By Ian in forum Excel General
    Replies: 5
    Last Post: 03-30-2005, 06:06 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