Excel 2002: How to pick up data from multiple columns ?

[Mr. Low]

Hi,

I have the following table at my worksheet:

Each row contains only a text or a number.

A B C D
1 Hp Hp <- only one entry per row
2 Qt Qt
3 Kx Kx
4 Qt Qt
5 Hp Hp
6 Kx Kx
2500


May I know what formula to input at cell D1 and copy down to pick up the
data from each cell in column A to C as illustrated ?

Thanks

Low

 

[Pete_UK]

Put this in D1:

=A1 & B1 & C1

and copy down as required.

Hope this helps.

Pete