Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Experts,
I need to reformat my cell content to display with bullets. For example: Sentence one [line break] Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two [line break] [line break] Sentence three Macro (or simple reformatting?) should run and replace text so that: - Sentence one [line break] - Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two Sentence two [line break] [line break] - Sentence three I created a macro that replaces line breaks so that a bullet appears on the next line but that doesn't really cut it because the first line is missing the bullet, and any extra lines get a bullet that doesn't belong. Sub insertbullets() For Each c In ActiveCell.CurrentRegion.Cells c.Value = Application.WorksheetFunction.Substitute(c, Chr(10), Chr(10) & "-") Next End Sub Any ideas? We are copying over a ton of content from PowerPoint and need to bring the bullet formatting over with it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
bullet formatting in a spreadsheet | Excel Discussion (Misc queries) | |||
Can you use bullet points for text within a cell in Excel? | Excel Discussion (Misc queries) | |||
Insert Bullet in E-Mail text | Excel Programming | |||
Bullet Points in Excel | Excel Discussion (Misc queries) | |||
how to add bullet list of text items in cell | Excel Programming |