I have an Excel 2007 workbook with 2 sheets in it, One for logging orders (Master List) and the other for the vendor who will process the order (Vendor List). In cell AL3 of the Master list sheet I enter what will be embroidered on the shirt using the return to break the words into seperate lines (see example below). How can I set up cell AI3 of the Vendor List to match the text including the returns?
='Master List'!AL3 copies the text but without the breaks.
I'm sure I'm being as clear as mud. Any help would really be appreciated.
Taylor Band
Mom
Alex '14
Mom
Alex '14
='Master List'!AL3 copies the text but without the breaks.
I'm sure I'm being as clear as mud. Any help would really be appreciated.