Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use a linking formula in cell with many words?
I have a form that has a bunch of text in it. Most of the cells in this form
have wrapped text. We would like to be able to fill in words in part of the text, based on information entered in another cell in the same worksheet, or workbook. Is it possible to do that if the cell has a paragraph in it? Can we, like in Word, insert a type of field, in the middle of that paragraph? Any suggestions, please let me know. Thank You! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use a linking formula in cell with many words?
Hopefully this is what you are looking for:
Example: Cell A1 is your field that is changeable (say a persons name) Cell B1 is your text so, B1 = "Dear " & A1 would produce Dear Mr ABC if cell A1 contained the value "Mr ABC". This also works with: B1 = "Congratulations " & A1 & " - you have won a prize!" this would give "Congratulations Mr ABC - you have won a prize!" (substitute your cells and text - hopefully you get the idea! "tmvigil95" wrote: I have a form that has a bunch of text in it. Most of the cells in this form have wrapped text. We would like to be able to fill in words in part of the text, based on information entered in another cell in the same worksheet, or workbook. Is it possible to do that if the cell has a paragraph in it? Can we, like in Word, insert a type of field, in the middle of that paragraph? Any suggestions, please let me know. Thank You! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use a linking formula in cell with many words?
Thank you so much! Works like a charm.
"Boo" wrote: Hopefully this is what you are looking for: Example: Cell A1 is your field that is changeable (say a persons name) Cell B1 is your text so, B1 = "Dear " & A1 would produce Dear Mr ABC if cell A1 contained the value "Mr ABC". This also works with: B1 = "Congratulations " & A1 & " - you have won a prize!" this would give "Congratulations Mr ABC - you have won a prize!" (substitute your cells and text - hopefully you get the idea! "tmvigil95" wrote: I have a form that has a bunch of text in it. Most of the cells in this form have wrapped text. We would like to be able to fill in words in part of the text, based on information entered in another cell in the same worksheet, or workbook. Is it possible to do that if the cell has a paragraph in it? Can we, like in Word, insert a type of field, in the middle of that paragraph? Any suggestions, please let me know. Thank You! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
assign formula to another cell | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |