Forum Discussion
Adding the integers before a certain string in a single cell
I would like to seek help for the following problem: I wish to add the integers before certain strings in a single cell. See detailed image below:
I think a VBA Macro in which adds all integers...
Hi Wyn,
Thank you for your response.
Yes there is a reason in which data has to be entered this way. I will have to evaluate multiple cells in this format.
Hi Kristian
Here's a version that can handle multiple rows.
I've added 2 options (one uses a slightly newer feature which is split to rows)
It does rely on the fact that the string is always 1 character