need to remove zero while joining two strings

[gmangad]

can anyone help me to remove the zero from the attached file - worshee
name is"printout" from cell B24-B32 ??

Attachment filename: telephone.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=39645

 

[Bob Phillips]

see response in .misc group.

--

HTH

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

 

[Leo Heuser]

One way:

Use this formula in the column B-cells:

=IF(SORT!A24&SORT!B24="0","",SORT!A24&SORT!B24)

 

[gmangad]

Thank you Leo

 

[Leo Heuser]

You're welcome.

LeoH