Unfortunally, CONCATENATE function dowsn't work that way.
Here, look at this solution with UDF function (you must comfirm it with ctrl+shift+enter and not just enter):
Unfortunally, CONCATENATE function dowsn't work that way.
Here, look at this solution with UDF function (you must comfirm it with ctrl+shift+enter and not just enter):
Last edited by zbor; 10-31-2012 at 10:30 AM.
Never use Merged Cells in Excel
Thanks Zbor...but when I tried your formula, I get a #NAME? error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks