Have you looked in the help index for
concatenate
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ATHER" wrote in message
...
How do I use the concatenate function to merge data from separate cells?
appreciate it very much if somebody could explain with a simple example.