Using a formula for column A:

=--SUBSTITUTE(MID(A5,FIND(",",A5)+1,255),",","")

Note that if any of the numbers have leading zeros that formula will drop
them.

[1] =,026, will result in 26.

If you have leading zeros then this will include them *but* the result will
be a *TEXT* value:

=SUBSTITUTE(MID(A5,FIND(",",A5)+1,255),",","")

Since column C also contains text characters you need to use the version
without the "--". The "--" coerces text numbers to numeric numbers.

--
Biff
Microsoft Excel MVP


wrote in message
...
Hi Group,

I have the following values in the cells A5 thru A11106.

I am trying to have a macro or a forumula to have the values after =
and without commas in its corresponding cell in the column B.

[1] =,26,
[2] =,126,
[3] =,5626,
[4] =,276,
[5] =,228896,
....
....
....

Result:

26
126
5626
276
228896

The following values in the cells C5 thru C11106. I am trying to write
macro to have the values after = and without commas in its
corresponding cell in the column D.


b[1] =,26,
nuiio[2] =,126gf,
f[3] =,g5626,
dw[4] =,276,
eef[5] =,228896,
....
.....
Result:

26
126gf
g5626
276
228896

I've already in the process of debugging my formula/code to achieve
this but no luck so far. Thought of writing to the group...
Please let me know how can I achieve this.

Thanks,
Kevin