+ Reply to Thread
Results 1 to 8 of 8

Need Help Using CHAR(10) On Multiple Lines With Same Value

  1. 09-22-2023, 06:20 PM #1
    Duffm4n1137
    Duffm4n1137 is offline
    Registered User
    Join Date
    09-22-2023
    Location
    Dover, New Hampshire
    MS-Off Ver
    Excel 365
    Posts
    2

    Need Help Using CHAR(10) On Multiple Lines With Same Value

    Hello,

    I will post a picture below of what I am trying to accomplish if possible. I am basically trying to save myself time by not manually using CHAR(10) on hundreds of rows to combine rows with the same name. Is there a way to do this automatically for rows with the same value in column A?

    WRONG.PNG - What I start with

    RIGHT.PNG - End result after using CHAR(10)
    Reply With QuoteRegister To Reply
  2. 09-22-2023, 07:12 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,503

    Re: Need Help Using CHAR(10) On Multiple Lines With Same Value

    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Adjust the range as required. Use Remove Duplicates. Or, you could use UNIQUE:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 09-23-2023, 04:48 AM #3
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: Need Help Using CHAR(10) On Multiple Lines With Same Value

    Everything in one go:

    Please try
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 09-23-2023, 05:14 AM #4
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,929

    Re: Need Help Using CHAR(10) On Multiple Lines With Same Value

    Another way,

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 09-23-2023, 07:12 AM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Need Help Using CHAR(10) On Multiple Lines With Same Value

    Or (same result - just a bit shorter):

    =LET(a,A1:A100,b,B1:B100,c,UNIQUE(a),d,MAP(c,LAMBDA(x,TEXTJOIN(CHAR(10),,FILTER(b,a=x)))),DROP(HSTACK(c,d),-1))
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  6. 10-11-2023, 08:40 AM #6
    Duffm4n1137
    Duffm4n1137 is offline
    Registered User
    Join Date
    09-22-2023
    Location
    Dover, New Hampshire
    MS-Off Ver
    Excel 365
    Posts
    2
    Quote Originally Posted by TMS View Post
    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Adjust the range as required. Use Remove Duplicates. Or, you could use UNIQUE:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Thank you!
    Reply With QuoteRegister To Reply
  7. 10-11-2023, 10:07 AM #7
    Jacc
    Jacc is offline
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,885

    Re: Need Help Using CHAR(10) On Multiple Lines With Same Value

    Wait for me! I wanna play this game too!
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    It doesn't spill though, you have to drag it down.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
    Reply With QuoteRegister To Reply
  8. 10-11-2023, 11:39 AM #8
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,503

    Re: Need Help Using CHAR(10) On Multiple Lines With Same Value

    Thank you!
    You're welcome.



    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.


    Might be interesting to indicate which solution you went with and why. Lots of options there
    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. Separate string of text, based on dynamic 3-char, 4-char and spaces, into columns
    By Christopher135 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-24-2023, 07:03 PM
  2. How to Find the position of each char. in a range of char. ?
    By Raph M in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-07-2022, 01:35 PM
  3. Copy individual lines from cell with broken lines by char(10)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2015, 05:40 AM
  4. [SOLVED] How to combine FINDing CHAR(42) and CHAR(47) in 1 formula
    By RJK in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-05-2015, 02:54 AM
  5. Changing a single Char in a string to another ASCII char
    By goofy78270 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-15-2007, 09:45 AM
  6. 8500 cells with phone number(7 char.), wishing to add area code (10 char.)
    By moparz@gmail.com in forum Excel General
    Replies: 6
    Last Post: 03-10-2006, 01:15 PM
  7. How do I change a data series from bars to lines in an Excel char.
    By mrocke in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-28-2005, 09:06 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