Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-15-2021, 05:59 PM
Rayroshi Rayroshi is offline Make a Macro Run In 'Search and Replace?' Windows 7 64bit Make a Macro Run In 'Search and Replace?' Office 2003
Novice
Make a Macro Run In 'Search and Replace?'
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to search names/ids and replace text in another column Kalü Excel Programming 1 12-06-2018 07:14 PM
Adding terms to a search & replace macro Ulodesk Word VBA 6 03-29-2018 05:30 AM
Macro on Search and Replace davidhuy Word VBA 1 12-19-2014 04:47 AM
Make a Macro Run In 'Search and Replace?' Macro to search warning text style and replace the text color rohanrohith Word VBA 3 11-27-2014 01:08 PM
Search and Replace - Clear Search box JostClan Word 1 05-04-2010 08:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft