Many thanks for your detailed response.

I've got a new query now that is similar to the previous question.

I have a forumula in Column B2 of my worksheet

=CONCATENATE(C2,\":\",F2,\";\",E2,\";\",H2,\";\",K 2,\" - \",P2)

When I copy this formula down through a number of cells I get the
output

:;;; -


What I'm looking for is a formula to say if the cell is blank(empty)
don't concatenate the cells just return a null value ie leave it empty
and don't return *:;;; -
*

Thanks for any help


--
Max_power
------------------------------------------------------------------------
Max_power's Profile: http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=530903