Global change

We may do that to

(1) the entire document,

(2) the active sheet

(3) only in formulas

But we can't restrict to a selected range.

Yvan KOENIG (VALLAURIS, France) mardi 28 février 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

Adding to Yvan's comments:

You could:

• Make the selection.
• Copy
• Insert a new Sheet (and it's default table)
• Click on the top left regular cell in the table (usually B2)
• Paste
• Do the "Find" and "Replace All" as shown here (English language/Roman numeral version of Yvan's image)
  
• Close Find/Replace
• Select the cells containing the results
• Click the icon of the source table, then click the top left cell of the cells that were selected.
• Go Edit > Paste and Match Style (to preserve any formatting done in these cells).
• When all is done, you can delete the added sheet and it's table.

Regards,

Barry