+ Reply to Thread
Results 1 to 8 of 8

Concatenatex and bulleted list

  1. #1
    Registered User
    Join Date
    04-05-2022
    Location
    San Francisco, CA
    MS-Off Ver
    2203
    Posts
    4

    Concatenatex and bulleted list

    Hello, I am using the following formula in a Pivot Table =CONCATENATEX(Range,[Priorities]," • ") so that I can display text values.

    I end up with values in a cell that look like this

    Some priority • Another priority • A third priority, • etc

    The above text wraps in the cell and is working exactly as it is supposed to work. However, I am wondering if there is some modification I can make to the formula to have the text display in the cell as

    • Some priority
    • Another priority
    • A third priority

    The number of text items will vary between none and 12 lines of text.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Concatenatex and bulleted list

    try to incorporate CHAR(10) into the formula, one for each return you want, that should add what you want.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    04-05-2022
    Location
    San Francisco, CA
    MS-Off Ver
    2203
    Posts
    4

    Re: Concatenatex and bulleted list

    Thanks -- I tried the char(10) but the number of elements varies. And I tried a few ways to insert char(10)and none seem to work.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Concatenatex and bulleted list

    Perhaps you can follow the instructions in the yellow box at the top and post a small sample work sheet with expected result.

  5. #5
    Registered User
    Join Date
    04-05-2022
    Location
    San Francisco, CA
    MS-Off Ver
    2203
    Posts
    4

    Re: Concatenatex and bulleted list

    I have attached a small spreadsheet that shows the current and the desired result
    Example.xlsx
    Thanks very much for taking a look at this.
    Much appreciated
    Attached Files Attached Files

  6. #6
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Concatenatex and bulleted list

    Hi,

    SHIFT+ENTER after your bullet symbol in the DAX formula works for me, providing you also have the Pivot Table cells set to Wrap Text.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  7. #7
    Registered User
    Join Date
    04-05-2022
    Location
    San Francisco, CA
    MS-Off Ver
    2203
    Posts
    4

    Re: Concatenatex and bulleted list

    Thanks very much. This worked for me but slightly differently. I found I had to put the shift enter right after the first quote. That worked for me.
    Thanks again.

  8. #8
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Concatenatex and bulleted list

    This is your example with the formula and my vision returned. You have to enable wrap text for it to work too. See your base data tab cell E2.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How can I create a bulleted list from a comma separated list?
    By kitkat23 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-24-2022, 06:04 PM
  2. [SOLVED] VBA for Bulleted List in Text Box
    By JYTS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-22-2020, 04:05 PM
  3. [SOLVED] Textbox - numbered/bulleted list ?
    By Lukael in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-04-2015, 03:28 AM
  4. Automatic bulleted list not created even though tab checked
    By drajanm in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 05-23-2013, 02:59 AM
  5. creating a bulleted list in a Word document
    By perducci in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2012, 04:21 PM
  6. Populating bulleted list in word.
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-05-2007, 04:12 AM
  7. Replies: 5
    Last Post: 02-01-2005, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1