Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |||
Help with Macor | New Users to Excel | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
Macor | Excel Discussion (Misc queries) | |||
How to create a macor to count the usage of another macor | Excel Discussion (Misc queries) | |||
Is there a forumula that uses colors instead of cell #'s? | Excel Discussion (Misc queries) |