LinkBack URL
About LinkBacks
In the attached file I am trying to elminate the zeros from the list when I concatenate the list.
JIm O
In the attached file I am trying to elminate the zeros from the list when I concatenate the list.
JIm O
Last edited by JO505; 01-01-2015 at 04:58 PM.
Try this...
=TRIM(SUBSTITUTE(B2&" "&C2&" "&D2,"0",""))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
One way,in F2 copied down
Formula:
=B2&IF(C2<>0," "&C2&IF(D2<>0," "&D2,""),"")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks to both of you,
That is what I was looking for.
Jim O
As an aside, Richards formula will allow zeros as part of the desired value such as (H7 V0), where the substitute and trim option will show that value as (H7 V).
Last edited by JO505; 01-01-2015 at 05:34 PM.
THANK YOU!!! This helped me soooo much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks