View Single Post
 
Old 01-15-2021, 05:59 PM
Rayroshi Rayroshi is offline Windows 7 64bit Office 2003
Novice
 
Join Date: May 2011
Posts: 21
Rayroshi is on a distinguished road
Default Make a Macro Run In 'Search and Replace?'

Is it possible, using Word 2007, to place a macro into the 'Search/Replace' tool, so that it will find all possible ocurrences of the specified 'search' item, then replace them with the specified 'replace' item?

I have a long list of items in a receipt that contains a lot of spaces. The spaces make the receipt over 20 pages in length. By removing the spaces, it would shorten the receipt to only one page, which would make it nicer to print, of course.

So, for example, I would like to remove the spaces from this:

1. Great Value Honey Roasted Peanuts, 16 oz
Qty1
$1.98
($1.98/ea),

making it look like this:

1. Great Value Honey Roasted Peanuts, 16 oz Qty1 $1.98 ($1.98/ea)


Not sure how to do that, so any help would be greatly appreciated. (The actual receipt has far more spaces than what I have shown)
Reply With Quote