Combining cell values on different Excel sheets

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

HeavyBall

Thread Starter
Joined
Oct 29, 2004
Messages
72
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?
 

Glaswegian

Malware Specialist
Joined
Dec 5, 2004
Messages
3,823
HeavyBall said:
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?
Hi

If you are combining data from just one sheet then your second reference should be Sheet1 and not Sheet2 - or have I misunderstood?

Regards
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Top