If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
replace a word with another word through out workbook
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. |
#2
|
|||
|
|||
replace a word with another word through out workbook
One way would be to concatenate if Company Name is in A1.
=CONCATENATE("The best company is ",Sheet1!A1," based in San Jose.") The best company is Smith Printing based in San Jose. "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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|