Hi Everyone!

I'm trying to produce a cell with info depending on data in 4 other cells. The cell I want to produce basically summarises the other 4 cells into 1. All cells contain data which is both numbers and letters.

I want cell D10 to look like this: "C10_A10_B10_E10" i.e. "John Smith_28_Smoker_19041986"

John Smith is the text in C10
28 is the data in A10
etc.

The _ symbols will be added in D10 only.

If anyone knows how to do this it would me much appreciated!!

Thanks
Dave