#1
|
|||
|
|||
Advanced search and replace for bullet points
I have a series of Word tables that I want to import to Excel. Some of the table cells have carriage returns and indented bullet points in them. I would like to replace these before importing into Excel. E.g. I have successfully replaced the paragraph marks with text such as 'zzzz' which can then be re-replaced in Excel, but I can't seem to find an option for search and replace of a bullet character and indent. Can anyone help?
TIA TishyMouse |
#2
|
||||
|
||||
If you want to replace the bullets with other formatting, or another style, you could try the Select All X Instances feature on the context (right-click) menu in the Styles pane. You will have to change the Styles Pane Options so that Word displays bullet and number formatting as entries in the Styles pane.
__________________
Stefan Blom Microsoft Word MVP Microsoft 365 apps for business Windows 11 Professional |
#3
|
|||
|
|||
Thanks for your reply and I guess that should work beautifully in a document where the styles have been properly applied but unfortunately ....
I have changed the Styles Pane option to show the bullet and number formatting options, but when I select a sample piece of bulleted text it is showing up as 'Normal' text albeit a modified version of it. i.e. I select the text and in the style pane the style 'Normal' is highlighted. If I right click on this I get the option 'Update Normal to match selection'. None of the 'bullet' type styles in the Styles list actually correspond to the superset of the text that I want to select. I can demonstrate this by right clicking on each 'bullet' style and seeing how many instances of that style exist in the document (very few). Any other ideas??? |
#4
|
||||
|
||||
Doesn't Select All X Instances work either, if you right-click on a Styles pane entry that says something like "Bulleted, Wingdings (symbol)"? Sometimes these entries, which are not actual styles, start with a style name.
__________________
Stefan Blom Microsoft Word MVP Microsoft 365 apps for business Windows 11 Professional |
#5
|
|||
|
|||
Ah I just spotted those at the bottom of the style list. Yes they work. Thanks!!
|
#6
|
||||
|
||||
You are welcome!
__________________
Stefan Blom Microsoft Word MVP Microsoft 365 apps for business Windows 11 Professional |
Tags |
advanced search, bullets |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Advanced find - default search all | AdamSitra | Word | 0 | 08-03-2011 04:33 AM |
Line appears with bullet points | Sequitorian | Word | 0 | 08-24-2010 03:52 PM |
Bullet points are messed up | TempleClause | Word | 4 | 06-08-2010 11:53 AM |
Bullet points shortcut | OfficeAppentice | Word | 1 | 04-30-2010 04:13 PM |
custom bullet points - stop image resizing | dlee388 | PowerPoint | 1 | 12-29-2009 04:47 PM |