Results 1 to 25 of 25

Concatenate Text and Trim Symbol

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-02-2004
    Location
    malaysia
    Posts
    342

    Concatenate Text and Trim Symbol

    Hi All,
    I need some guides and tips to Concatenate some texts and trim the "+" symbol based on condition. If A1=apple, A2=banana and A3=orange, to Concatenate all with "+" sign, I can simply use (A1)&""&"+"&" "&(A2)&""&"+"&" "&(A3) to make up apple + banana + orange. However, if I delete A3 orange, it returns as apple + banana + , how do I set a formula to trim the last "+" sign if there are only 2 texts? Same problem with only 1 text where it return wrongly as apple + + . Any help is greatly appreciated.
    Last edited by seanyeap; 04-12-2010 at 10:10 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1