+ Reply to Thread
Results 1 to 5 of 5

Help needed: Spliting single cell into two

  1. #1
    Registered User
    Join Date
    10-03-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    67

    Help needed: Spliting single cell into two

    Hi all,

    I need an help to split the single into two, is this really possible in excel?

    To be precise dividing cell A1 into two different cells(No merging, No text to column option).

    Thanks

    Elango

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Help needed: Spliting single cell into two

    Not quite precise enough.

    Can you provide examples of data within the cell and define where to split the cell?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Help needed: Spliting single cell into two

    If you are meaning to split one physical cell in half to have 2 independent cells, that is not possible in Excel.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    10-03-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    67

    Re: Help needed: Spliting single cell into two

    Oops!!! anyway thanks to both of you

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Help needed: Spliting single cell into two

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Spliting cell contents
    By neeraj vaze in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-07-2014, 01:39 AM
  2. Multi Line Cell Spliting
    By SamLPC in forum Excel General
    Replies: 17
    Last Post: 07-29-2011, 05:34 PM
  3. Spliting data in the same cell
    By sentinela in forum Excel General
    Replies: 6
    Last Post: 03-24-2009, 03:35 PM
  4. Spliting a name cell
    By rachew in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2007, 06:56 AM
  5. [SOLVED] Spliting the contents of a cell to other cells
    By Lime in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-14-2005, 12:31 PM

Tags for this Thread

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