Use and If statement and concantenate, other than that we will need an
example.

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Dave F" wrote in message
...
I would like to be able to essentially copy and paste a string of cell
values
in a cell controlled by an IF statement. Any thoughts anyone?

Thanks
--
Dave