Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Adding Bullets in single cell

0

Hi,

I like to add bullets in a single cell.

I have all the information available in a row as, Description - (A1), Feature 1 (B1), Feature 2 (C1), Feature 3 (D1), Feature 4 (E1), Feature 5 (F1). Now I want to gether all the features with bullets in a single cell of Description (A1) like following example: 

Description - (A1)

  • Feature 1 (B1)
  • Feature 2 (C1)
  • Feature 3 (D1)
  • Feature 4 (E1)
  • Feature 5 (F1)

I tried use the below formula, but it is not returning as above example. Please guide how can I get the desired result.

=CONCATENATE(W6, " ",CHAR(2),CHAR(149),CHAR(2), X6, " ",CHAR(2),CHAR(149),CHAR(2),Y6," ",CHAR(2),CHAR(149),CHAR(2), Z6," ",CHAR(2),CHAR(149),CHAR(2),AA6)

Regards,

Kamran Mehmood

[PERSONAL INFO REMOVED - Do not post emails/phone numbers unless you want the whole world to spam you - this is a public forum]

excel
posted by: Kamran Mehmood on Fri Feb 18, 2022 at 2:57 pm
Post Edited
Personal Information: Personal information was removed from the post, such as an email address.
Answer
Discuss

Discussion

Kamran

I've provided an answer but suggest you remove your personal details (email, phone number) from your Question (use Edit to do so)- in general we don't use these in the Forum for privacy/ data protection reasons.
John_Ru (rep: 6152) Feb 19, '22 at 5:42 am
@Kamran- no need to do the above now -@Don- thanks for editting the question to remove personal data
John_Ru (rep: 6152) Feb 21, '22 at 7:12 am
Add to Discussion

Answers

0

Hi Kamran and welcome to the Forum.

You can use ASCII character 10 (Line Feed) to separate the lines with CHAR(10)- this is equivalent to keystroke Alt+Return within a cell. In my opinion, you can discard the CHAR(2) parts and use " " instead in this formula (changes in bold): 

=CONCATENATE(W6,CHAR(10), "  ",CHAR(149)," ",X6,CHAR(10),  "  ",CHAR(149)," ",Y6,CHAR(10), "  ",CHAR(149)," ", Z6,CHAR(10), "  ",CHAR(149)," ",AA6)

 but be sure to set Word Wrap on in the cell so it displays properly.

To make it shorter and easier to read, you can just use:

=W6 & CHAR(10) & "  " & CHAR(149) & " " & X6 & CHAR(10) &  "  " & CHAR(149) & " " & Y6 & CHAR(10) & "  " & CHAR(149) & " " & Z6 & CHAR(10) & "  " & CHAR(149) & " " & AA6

Hope this helps.

posted by: John_Ru (rep: 6152) on Sat Feb 19, 2022 at 5:34 am
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login