Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I insert a cell reference into a block of text?
I need add several personalised statements a list of names. There are
several variations of each statement containing he/she, first name etc. The results are then mailmerged with other standard information into a Word document. What I would like to do would be able to insert a cell reference for "First Name" , "he/she" into the relevant place in each statement . Any suggestions please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I insert a cell reference into a block of text?
I think you can do what you want with the TEXT function and concatenation
operator (&). Your formula would be something like =A1 & " has been on the job for " & text(A2/365,"0.#") & " years." This combines fixed text with variable data formatted to your specs. "painterpat" wrote: I need add several personalised statements a list of names. There are several variations of each statement containing he/she, first name etc. The results are then mailmerged with other standard information into a Word document. What I would like to do would be able to insert a cell reference for "First Name" , "he/she" into the relevant place in each statement . Any suggestions please? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I insert a cell reference into a block of text?
what you are proposing is exactly what you can do in a "mailmerge"
-- paul remove nospam for email addy! "painterpat" wrote: I need add several personalised statements a list of names. There are several variations of each statement containing he/she, first name etc. The results are then mailmerged with other standard information into a Word document. What I would like to do would be able to insert a cell reference for "First Name" , "he/she" into the relevant place in each statement . Any suggestions please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Cell Capacity - text | Excel Discussion (Misc queries) | |||
can I reference a sheet name in a cell as text? | Excel Worksheet Functions | |||
dynamic cell reference within a text string | Excel Worksheet Functions |