pulling out Numbers

[Ron Rosenfeld]

thanx Ron.It's excellent

You should look at some of the references I gave Mike to learn about
constructing regular expressions. There are also many other ways to use them.
--ron

 

[Guest]

hi Ron,
where should I locate the following commands in the UDF codes?
=resub(A1,"\d","") or =resub(A1,"\D",""), =resub....
and what does A1 or A6 stand for?
thanx

 

[Ron Rosenfeld]

hi Ron,
where should I locate the following commands in the UDF codes?
=resub(A1,"\d","") or =resub(A1,"\D",""), =resub....

I don't know what you mean by that question.

=resub(A1,"\d","") is a function you enter in a worksheet cell.

and what does A1 or A6 stand for?

A1 "stands for" the worksheet cell that is in the first row and first column of
your sheet (upper left corner).

A6 "stands for" the worksheet cell located in the 6th row of the first column.

In my first post, I used cell_ref for that. But I thought that by now you
would realize that these are just arbitrary cell references to where I happened
to have the test string.

If you are using the R1C1 reference system, then A1 is the same as R1C1, and A6
is the same R6C1.
--ron

 

[Guest]

Sorry Ron, I got it.thanx

I don't know what you mean by that question.

=resub(A1,"\d","") is a function you enter in a worksheet cell.


A1 "stands for" the worksheet cell that is in the first row and first column of
your sheet (upper left corner).

A6 "stands for" the worksheet cell located in the 6th row of the first column.

In my first post, I used cell_ref for that. But I thought that by now you
would realize that these are just arbitrary cell references to where I happened
to have the test string.

If you are using the R1C1 reference system, then A1 is the same as R1C1, and A6
is the same R6C1.
--ron

 

[Ron Rosenfeld]

Sorry Ron, I got it.thanx

No need to apologize. Sometimes I assume mind reading abilities where none
exists )
--ron