+ Reply to Thread
Results 1 to 4 of 4

How to split cells into 3 different cells

  1. 05-15-2015, 06:49 AM #1
    Ankit_Kumar
    Ankit_Kumar is offline
    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
    Reply With QuoteRegister To Reply
  2. 05-15-2015, 07:03 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: How to split cells into 3 different cells

    How does you data look like? Please attach a sample workbook
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  3. 05-18-2015, 03:18 AM #3
    Ankit_Kumar
    Ankit_Kumar is offline
    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
    Reply With QuoteRegister To Reply
  4. 05-18-2015, 03:31 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    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.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Urgent .... How to split cells in Excel... Working with Tables and Cells at a time
    By Vanga Sasidhar in forum Excel General
    Replies: 1
    Last Post: 02-11-2006, 01:00 PM
  4. split cells
    By mwuttke in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 03:05 PM
  5. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1