Be sure to press the YES button below to indicate your question has been
answered (specifically on JE McGimpsey's post that solved most of your
question).
--
** John C **

"Chops" wrote:

Thanx

Like I sd I am new to this but I knew I could get the help. You all have
been great now I am off to try it

Again
Thanx
Carolin

"John C" wrote:

Say your formula is in B1, and you need to copy it down to B18000.
Press CTRL+G (GoTo), type in the box B1:B18000, then go to menu
Edit--Fill--Down, and voila.
--
** John C **

"Chops" wrote:

This is perfect I just have one other question when I am doing the dragging
is there an easier way then just dragging to the bottom because I have over
18000 rows I am going thru.

Thanx
Carolin

"JE McGimpsey" wrote:

Assuming the values are in column A.

1) Click on B1
2) Enter the formula below
3) Grab the fill-handle of B1 (lower right corner), and drag down as far
as required
4) Select columns A:B
5) Choose Data/Autofilter
6) In the B1 dropdown, choose Custom Filter
7) Using the dropdown and combobox, choose "is less than or equal to" 2
8) Click OK


In article ,
Chops wrote:

Ok I will try this, so do I click on column B and then what do I do. Sorry I
am so new to this.

Thanx
Carolin

"JE McGimpsey" wrote:

No, but a modification of the third one will:

=COUNTA(A1)+LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))