Retreive part of the value from each cell - Macro and/or forumula
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
|