Merging to excel

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

hi,

is it possible to merge information into excel in the same
way you can in ms word

cheers
dave
 
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
 
Or did you mean taking data from more that one Sheet?
=[Book2.xls]Sheet1!$A$1

Bernard
 
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
Click to expand...


.
Click to expand...
 
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.
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
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top