Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|