need to remove zero while joining two strings
 

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
--
Message posted from http://www.ExcelForum.com

need to remove zero while joining two strings
 

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)

"gmangad " wrote in message
...
can anyone help me to remove the zero from the attached file - worsheet
name is"printout" from cell B24-B32 ???

Attachment filename: telephone.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=396452
---
Message posted from http://www.ExcelForum.com/

need to remove zero while joining two strings
 

One way:

Use this formula in the column B-cells:

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

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"gmangad " skrev i en meddelelse
...
can anyone help me to remove the zero from the attached file - worsheet
name is"printout" from cell B24-B32 ???

Attachment filename: telephone.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=396452
---
Message posted from http://www.ExcelForum.com/

need to remove zero while joining two strings
 

Thank you Leo


---
Message posted from http://www.ExcelForum.com/

need to remove zero while joining two strings
 

You're welcome.

LeoH


"gmangad " skrev i en meddelelse
...
Thank you Leo


---
Message posted from http://www.ExcelForum.com/