View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default replace a word with another word through out workbook

Assuming "pages" are worksheets, you would need linking formulas in all
cells in which you would want the company name inserted.

="This is coming to you from " & Sheet1!A1 & " which is a great company"

To insert a text string into existing text strings would require VBA


Gord Dibben MS Excel MVP

On Mon, 8 Dec 2008 12:06:12 -0800, adam
wrote:

I am creating a workbook with multiple pages. I would like to type a company
name on the first page and have it placed in the middle of sentences through
out the work book.