A zero appearing after joining two strings

[gmangad]

I am attaching a file.
I have 3 sheet.

The first sheet called "DATA" is to enter data- it is ok.

In the second sheet called "SORT", it removes the name starting with
'MULLA" or "SHEIKH" and replace the name and I will be sorting the name
without 'MULLA' OR 'SHEIKH'

In the Third sheet called "PRINTOUT" it joins the name with 'MULLA' and
'SHEIKH' .
Everything is working ok till here.
the problem is - in my 'PRINTOUT' sheet, a zero is appearing where
there is no corresponding data. How can I remove the zero?

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

 

[Bob Phillips]

Change the formula in PRINTOUT to
=IF(SORT!A5&SORT!B5="0","",SORT!A5&SORT!B5)

--

HTH

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