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

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

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???

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

Ah I just spotted those at the bottom of the style list. Yes they work. Thanks!!

You are welcome!

__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional