Assume values in ColA are actual valuesIn cell B1 enter the below formula and
copy down as required; Please note that this is an array formula. An array
formula can perform multiple calculations and then return either a single
result or multiple results. You create array formulas in the same way that
you create other formulas, except you press CTRL+SHIFT+ENTER to enter the
formula. If successful in 'Formula Bar' you can notice the curly braces at
both ends like "{=<formula}"

=IF(COUNTIF($A$1:$A$1000,"?*")<ROW(A1),"",INDEX(A$ 1:A$1000,
SMALL(IF($A$1:$A$1000<"",ROW($A$1:$A$1000)),ROW(A 1))))

--
Jacob


"Gotroots" wrote:

I want to remove the blanks in "A" using a formula in "B"

example:

A1 - sand
A2 -
A3 - silt

Formula in "B"

B1 - sand
B2 - silt

Thankyou