Joining two cells of text together in a different third cell in Ex

[Alfred Zeiler]

Example of what I'm trying to do with a bank reconciliation template I created:
Sheet 1 Cell A1 is "Acct #" and Cell B1 is the actual account number (say
10526) which gets changed for every different account.
In Sheet 2 I have several cells where I need "Acct # 10526" and cannot use
two cells to do it.
This in turn feeds a customer letter in Sheet 3 where I need to insert
several cells into the text at various places. The reason I use an Excel
sheet for the letter is because I have to manually type the detailed account
descepencies into a table that match one of the calculated cells used in the
letter (from Sheet 2).

I also have numerous non-numeric cells that need to be combined like the
above example. Only difference is both cells are labels and not one label &
one number.

I would gladly email someone the template for help.

 

[Paul B]

Alfred, how about something like this
=A1&" "&B1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Ramakrishnan Rajamani]

Use the =CONCATENATE function

-----Original Message-----
Example of what I'm trying to do with a bank

reconciliation template I created: