cocatenate
 

Try the following...

="or acct_num = '"&A1&"'"

Hope this helps!

jamphan Wrote:
I have in cell A1 an account number. I need to add text around this
number. Example:
In A1 I have 12345
I need to add:
or acct_num = ' '

The final outcome needs to look like :
or acct_num = '12345'

Is there any way I can do this making sure the ' ' marks are in front
and behind the number? Thanks for the help!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=346783