D
Dave
hi,
is it possible to merge information into excel in the same
way you can in ms word
cheers
dave
is it possible to merge information into excel in the same
way you can in ms word
cheers
dave
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard V Liengme
To combine test into one cell use: A1&B1&C1 etc or if spaces are needed A1&"
"&B1&" "&C1
To convert the results to values use Edit followed by Paste Special/Values
Select all the cell with formulas, click the Copy tool, immediately open the
Edit menu, locate PasteSpecial and check the Value box.
Bernard
"&B1&" "&C1
To convert the results to values use Edit followed by Paste Special/Values
Select all the cell with formulas, click the Copy tool, immediately open the
Edit menu, locate PasteSpecial and check the Value box.
Bernard
B
Bernard V Liengme
Or did you mean taking data from more that one Sheet?
=[Book2.xls]Sheet1!$A$1
Bernard
=[Book2.xls]Sheet1!$A$1
Bernard
D
Dave
sorry, i think my post was slightly vague
i meant a mail merge, as in i have info in a database and
would like to produce a form based in an excel sheet which
is then printable for all records which appear in the
database, ie name, address etc
apologies
dave
i meant a mail merge, as in i have info in a database and
would like to produce a form based in an excel sheet which
is then printable for all records which appear in the
database, ie name, address etc
apologies
dave
-----Original Message-----
Or did you mean taking data from more that one Sheet?
=[Book2.xls]Sheet1!$A$1
Bernard
Dave said:hi,
is it possible to merge information into excel in the same
way you can in ms word
cheers
dave
.
D
Dave Peterson
You could build a macro that would take the imported data and populate a
worksheet. Then print it, then advance to the next record, populate, print,
etc.
But it's not built into excel like it's built into Word.
worksheet. Then print it, then advance to the next record, populate, print,
etc.
But it's not built into excel like it's built into Word.
sorry, i think my post was slightly vague
i meant a mail merge, as in i have info in a database and
would like to produce a form based in an excel sheet which
is then printable for all records which appear in the
database, ie name, address etc
apologies
dave
-----Original Message-----
Or did you mean taking data from more that one Sheet?
=[Book2.xls]Sheet1!$A$1
Bernard
Dave said:hi,
is it possible to merge information into excel in the same
way you can in ms word
cheers
dave
.