+ Reply to Thread
Results 1 to 11 of 11

Join text using parentheses and ignoring blanks

Hybrid View

  1. 09-05-2024, 11:01 AM #1
    ByteMarks
    ByteMarks is offline
    Forum Expert ByteMarks's Avatar
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    3,086

    Re: Join text using parentheses and ignoring blanks

    Another way
    =TRIM(A2&SUBSTITUTE(" ("&B2&")","()",""))
    Reply With QuoteRegister To Reply
  2. 09-05-2024, 11:09 AM #2
    BSkill
    BSkill is offline
    Registered User
    Join Date
    06-26-2024
    Location
    Houston, Texas
    MS-Off Ver
    365
    Posts
    20

    Re: Join text using parentheses and ignoring blanks

    I appreciate the alternative - thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Text Join Indirect is including blanks
    By yorkshirewhite in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-10-2022, 05:14 PM
  2. Text join Dates, ignore duplicates and blanks
    By dandanrolando in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-20-2022, 10:52 AM
  3. Text join ignoring blanks but limited to a maximum of five entries
    By JFawcett in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-26-2020, 03:54 AM
  4. [SOLVED] SUMIF, ignoring blanks and find earliest date ignoring blanks
    By Chris_Devon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2019, 10:16 AM
  5. [SOLVED] Count or Sum Ignoring Specified Text & Blanks
    By mycon73 in forum Excel General
    Replies: 3
    Last Post: 11-24-2018, 03:26 AM
  6. [SOLVED] return text ignoring text in parentheses
    By Mike Brewer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2016, 10:00 AM
  7. [SOLVED] Extracting all text from parentheses (including parentheses)
    By j4ke101 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-10-2013, 08:03 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1