Forum Discussion
Solved
Combining Text and data from a table in excel
Hi All, I have a task which requires me to follow up exception events that occur each day. This involves hundreds of exceptions, the information of which comes from a report. Thanks to help wond...
You had two problems: One, cell references shouldn't be contained in quote marks, because they're not text. Two, line breaks can't be entered into formulas in the way you had done - you have to use CHAR(10) to represent a line break.
I think this should be working now.
