| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need to remove zero while joining two strings
|
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
| joining worksheets | Excel Worksheet Functions | |||
| remove line breaks in text strings | New Users to Excel | |||
| How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
| remove leading zeros from text strings | Excel Worksheet Functions | |||
Linear Mode
