Hello,
I am having difficulty using the following macro to concatenate text strings over the 255 character limit.
Please see the example spreadsheet. Cell G2 works fine, even though I have a lot more total characters than G1. G1 is the one that I want to work properly. There is something it doesnt like in cell A1 that is causing the problem. The formula I am using in the cell is:
So, it places a bullet before the first cell, and also in front of each subsequent entry/cell (that isnt blank) and also puts the new cell on a new line. I really want to have everything show up in 1 cell. Any ideas what Im doing wrong, or is there another way to do this? Thanks!!!
Bookmarks