Thread: replace a word with another word through out workbook
View Single Post
  #3  
Old December 8th, 2008, 08:36 PM posted to microsoft.public.excel.worksheet.functions
Joel
external usenet poster
  
Posts: 2,855
Default replace a word with another word through out workbook
The best way is to use the & to connect strings

="My Company Name is " & Sheet1!A1

="Company " & Sheet1!A1 & "owes " & Sheet1!B2 & " Dollars"

"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.