View Single Post
 
Old 12-09-2021, 03:20 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,166
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Search and replace from an Excel table is relatively straightforward but if you want to include formatting as well it becomes a whole different ballgame.

I would recommend the source table be in Word format so you have more flexible formatting options which don't require special handling. Are you able to set up a Word source for the replacements or does it HAVE to be in Excel?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote