+ Reply to Thread
Results 1 to 3 of 3

Concatenate a Spill

  1. 07-25-2023, 01:58 PM #1
    purgamentum
    purgamentum is offline
    Registered User
    Join Date
    05-02-2020
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 2019
    Posts
    68

    Question Concatenate a Spill

    Don't think I need to post any code.
    I have a formula that pulls information from a database, 95% of the time there's only one return but sometimes there's 2 or 3.

    Looking for a way to concatenate the result instead of having it spill, any thoughts?
    Reply With QuoteRegister To Reply
  2. 07-25-2023, 02:12 PM #2
    dosydos
    dosydos is offline
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,474

    Re: Concatenate a Spill

    try the Textjoin() formula
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
    Reply With QuoteRegister To Reply
  3. 07-25-2023, 02:24 PM #3
    purgamentum
    purgamentum is offline
    Registered User
    Join Date
    05-02-2020
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 2019
    Posts
    68

    Re: Concatenate a Spill

    Quote Originally Posted by dosydos View Post
    try the Textjoin() formula
    Worked like a charm! Thank you !!
    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. Why would this SPILL?
    By xImtc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-05-2023, 12:00 PM
  2. [SOLVED] How to spill down instead of across
    By RaulSerg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-23-2022, 05:19 AM
  3. #spill! error
    By whburling in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-19-2022, 05:10 PM
  4. [SOLVED] Spill error
    By mary maggs in forum Excel General
    Replies: 3
    Last Post: 11-05-2021, 05:57 PM
  5. Spilled Formulas That Don't Spill Zero Values and Spill A Total?
    By MattheusB in forum Excel General
    Replies: 5
    Last Post: 01-27-2021, 12:07 PM
  6. SPILL Help
    By mrsak87 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2020, 07:10 AM
  7. [SOLVED] spill
    By april27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2006, 12:55 PM

Tags for this Thread

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