View Single Post
 
Old 03-23-2021, 02:54 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,164
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

Typically when people put in requests like this without providing a realistic sample document, the initial solutions don't fit because of things that aren't said. If you provided a sample doc you would get a much better solution since we can test the macro without having to make assumptions.

The specific questions I would need answered first are:
  1. Do your tables contain any merged cells?
  2. Your text says add 'english' to column 3 but your screenshot shows it in column 10. Which is correct?
  3. Does the c./v. replacement happen anywhere in the row or only in a specific row?
  4. Does the c./v. replacement happen only when there is a space in front of the c.?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote