pulling out Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
thanx Ron.It's excellent
Click to expand...

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
 
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
 
hi Ron,
where should I locate the following commands in the UDF codes?
=resub(A1,"\d","") or =resub(A1,"\D",""), =resub....
Click to expand...

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?
Click to expand...

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
 
Sorry Ron, I got it.thanx

Ron Rosenfeld said:
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
Click to expand...
 
Back
Top