Zeros in Linked Cells

[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

 

[Frank Kabel]

Hi
try
=IF(Sheet1!B3="",""Sheet1!B3) & IF(Sheet1!B4="",""Sheet1!B4)

 

[RichB]

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

 

[Frank Kabel]

Hi
what is exactly in B1 (really an empty cell?)
What does
=LEN(Sheet1!B1)
return?

 

[RichB]

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