How?

Juice Man

Place this in B1 and fill across:

=OFFSET($A$2,COLUMN()-2,)

HTH
Jason
Atlanta, GA

-----Original Message-----
How?

Juice Man

.

Hi

Into B1 enter the formula
=IF(A2="","",A2)
and copy down


Arvi Laanemets


"Juice Man" wrote in message
...
How?

Juice Man

If it's headlines:
A2:A10 right click Copy
B1 right click Paste Special Transpose

Done!
Ola

On Sun, 23 Jan 2005 22:51:33 +0200, "Arvi Laanemets"
wrote:

Into B1 enter the formula
=IF(A2="","",A2)

That looks to me like it's going to give exactly the same results as =A2. What
am I missing?

If a2 is empty, then =a2 will return a 0???



Myrna Larson wrote:

On Sun, 23 Jan 2005 22:51:33 +0200, "Arvi Laanemets"
wrote:

Into B1 enter the formula
=IF(A2="","",A2)

That looks to me like it's going to give exactly the same results as =A2. What
am I missing?

--

Dave Peterson