How to get Sub Array

[leibale]

from the array {"aa";"ab";"";"ac";""} I want a sub array with all the items that are not "" (only 3 items)
How to do it?

[leibale]

Or,
A1: AA
A2: AB
A3:
A4: AC
A5
I want a formula to get an array with the 3 cells with the text

[fairwinds]

Hi,

Try this:

Formula must be entered with ctrl + shift + enter in B2, then dragged down.

******** ******************** ************************************************************************>

Microsoft Excel - Book2 ___Running: xl2002 XP : OS = Windows 98
File Edit View Insert Options Tools Data Window Help About
B2B3B4 =
	A	B	C	D
1
2	AA	AA
3	AB	AB
4		AC
5	AC
Sheet5

[HtmlMaker light Ver1.11] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

[leibale]

it works. thank you. now i'l spend a time to understand it