cocatenate

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!

Try the following...

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

Hope this helps!

Originally Posted by jamphan

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!