Format problem?

[Guest]

Hi.. I have a worksheet that contains a list of names. I have a second worsheet that mirrors the list to perform some functions ie sheet A 1 Dav
2 Joh
3 Ro
sheet B =SheetA!A
=SheetA!A
et
The problem is that I have created formulas on sheet B that allows for growth in the name list, but blank cells in sheet B are returning a 0 value in each cell even when sheet A and B is formatted as text. So I cannot paste special and ignore blanks. I am therefore getting my output from sheet B as thi
Dav
Joh
Ro



et
Can anyone please offer advice...Thank

 

[Bob Phillips]

Johnny,

Why not try

=IF(SheetA!A1<>"",SheetA!A1,"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi.. I have a worksheet that contains a list of names. I have a second

worsheet that mirrors the list to perform some functions ie sheet A 1 Dave

2 John
3 Rob
sheet B =SheetA!A1
=SheetA!A2
etc
The problem is that I have created formulas on sheet B that allows for

growth in the name list, but blank cells in sheet B are returning a 0 value
in each cell even when sheet A and B is formatted as text. So I cannot paste
special and ignore blanks. I am therefore getting my output from sheet B as
this