I am having trouble doing the following:
I have an Excel workbook with two sheets. The first sheet contains two fields, one for first name and one for last name.
On the second sheet, I want to combine the two into one column called borrower name. Here is the formula I'm using:
='sheet1'!A1 & ", " & 'sheet2'!B1
this works on the same sheet as the source data (sheet1), but is ignored when on the second sheet.
Any ideas?
I have an Excel workbook with two sheets. The first sheet contains two fields, one for first name and one for last name.
On the second sheet, I want to combine the two into one column called borrower name. Here is the formula I'm using:
='sheet1'!A1 & ", " & 'sheet2'!B1
this works on the same sheet as the source data (sheet1), but is ignored when on the second sheet.
Any ideas?