+ Reply to Thread
Results 1 to 2 of 2

How to Split a Cell in Mac

  1. #1
    Registered User
    Join Date
    02-14-2020
    Location
    Paris
    MS-Off Ver
    2016 on Mac
    Posts
    81

    How to Split a Cell in Mac

    Hello,

    I am using Excel 2016 on Mac and I am looking for a solution to split a cell into multiple cells. However, it seems that this option in Layout is not available ?

    Can anyone advise ?

    Thank you.

    Najwa.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,718

    Re: How to Split a Cell in Mac

    You cannot split cells in Excel. If you think about it for a minute it will become clear why. Suppose you split cell A1 into two cells. What would be the addresses of the two new cells?

    (You can split table cells in Word, but you can't do the same thing in Excel.)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] How to split the contents of a cell separated by commas and linked to another cell
    By grim72 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2019, 11:01 AM
  2. Replies: 3
    Last Post: 11-05-2019, 03:02 AM
  3. Split cell contents and copy adjoing cell next to each resulting row.
    By vanman100 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2017, 02:04 PM
  4. Need Macro code to split data split in 7 sheets based on variable rows in column A
    By Alija_21 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-31-2015, 08:03 AM
  5. [SOLVED] create macro to split screen and then in top split, go to a certain cell
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-17-2015, 05:45 PM
  6. Split cell to create sorted heading on empty row above and keep second split info
    By CastingDirector in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2015, 12:24 AM
  7. Macro : Split text of a single cell into multiple cell
    By rampal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2012, 02:05 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