Zeros in Linked Cells

  • Thread starter Thread starter RichB
  • Start date Start date
R

RichB

I have a spreadsheet that is linked to another. Within the spreadshee
I have two cells in sheet1 linked to sheet2.

Sheet2!B2 = Sheet1!B3&""&Sheet1!B4

My problem is that if Sheet1!B3 is blank it returns a zero on the lin
on Sheet2!B2

0F

It should just be F

If both B3 and B4 are blank it gives me

00

I turned off zero values in all spreadsheets affected and it still doe
not work. Am I stuck with coding this out or is there something I ma
be missing.

Thanks
Rich
 
I have tried this.

=IF(Sheet1!B1="","",Sheet1!B1)&""&IF(Sheet1!B2="","",Sheet1!B2)

I just tried your variation and it still comes up with "0F
 
Hi Frank,


Interesting,

On the original/source sheet there is nothing.

On the 1st link there is a 1

On the last link shows the zero that I am trying to get rid of.

So . . . maybe a safe assumption is that it is counting the link as one
in the length?

Thanks for hanging in with this.
Rich
 
Back
Top