Forum Discussion
Spliting a block of cells in a column
Just for rows 76 thru 81, can Column B get split so Calendar names can be separate from person's name? Row Column A Column B Column C 69 67 Se...
Thank you Martin_Weiss
#1. I'm known to do things "dynamically" & believe in formulas so I'll go with #2.
#2. I'm disappointed. Now I have to create & populate the columns for the names & calendars. So much for Excel Magic. I expected you to have a magic formula that would do it for me, like waving some magic wand over the cell to do it automatically. SMILES, MariluWho
#3. Here's how I expected it to happen: highlight the cells from B76 thru B88 and separate that selection into columns. It is a block of text that will not have formulas so why not allow me to table that section of cells into 2 columns? why not? ...... cuz I'm just a "smidgeon" in this matter. (from the Scottish word smitch, "an insignificant person.")
Perhaps I'm not clear on this one requirement I'm trying to achieve. Column B is a table with two columns, 1 for name & 1 for calendar. I don't want to have to look to any other columns on my spreadsheet to see this info.