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

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


--
A36B58K641

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

Put this in D1:

=A1 & B1 & C1

and copy down as required.

Hope this helps.

Pete

On Aug 5, 2:33*pm, Mr. Low wrote:
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

--
A36B58K641