Glad I could help. Thanks for the feedback.

Fred.

"Question, Mark" wrote in message
...
Excellent! I was misplacing the quotation marks.
Thank you so much.

"Fred Smith" wrote:

Use this in C1:
=if(b1="","",a1)

Regards,
Fred

"Question, Mark" wrote in
message
...
I want to copy whatever is in A1 into C1 if B1 has data. If b1 is blank
then
c1 should remain blank. The data in a1 or b1 could be either text or
numbers. As long as anything is in b1 then c1 should contain whatever
is
in
a1.