Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Retreive part of the value from each cell - Macor and/or forumula | Excel Discussion (Misc queries) | |||
How to retreive the name of a named cell in an excel macro | Excel Programming | |||
Macro affecting hyperion retreive | Excel Programming | |||
Help with forumula to change text cell | Excel Programming | |||
Is there a forumula that uses colors instead of cell #'s? | Excel Discussion (Misc queries) |