How uniformize diferent types of Data (SOLVED)

Hello Gurus. This is my first time working on a macro.

I need to match data from two diferent tables in excel, and unfortanely, the data in the two tables isn't treated in the same way.

For example, in one table I have 2K2 (2,2*10^3), and on the other table I have 2,2K (also 2,2*10^3). As you can see, the value of the data is the same, but being that it isn't treated the same way, it doesnt't match. So I was thinking about making a cycle that would run all of both tables, and transform the data so it would be the same. For example 2K2 and 2,2K would become 2,2*10^3. Or 2K2 would become 2,2K.
(Example of the values Below)

Table 1 |Table2
4,300K |4K3
39,00C |39C
36,00P | 36P


Do you have any advice? I spent all day trying to find examples of how through cycle through a string, and if some condition was met, (for example, if my char was K) it would transform it to the value i wanted (10^3). But I feel like I'm way out of my league here.

Maybe this is very simple problem to solved, but I'm have no experience in programming macros. I appologize in advance if I'm breaking some forum rule.

Thanks for the Help.

Is the text indicator always "K" or do you also have values with "M" or "m" or "c" or other SI or similar prefixes?

If it's always K and it always means *10^3, I would go with something like:
1) A substitute function to get rid of the K. For table 1, substitute "K" with "" SUBSTITUTE(A2,"K",""). For table 2, substitute "K" with "," SUBSTITUTE(B2,"K",",")
2) Then mutliply the resulting number as text by 1000 (Excel will automatically convert to a number. In both cases =SUBSTITUTE(...)*1000

Will that work?

Yes, I think that sort of strategy would work.

I do not know if there is a simpler way. At the same time, my mentor taught me to program within my abilities rather than seek out procedures that I did not understand -- even if the way I understand is less efficient than what a more experienced programmer would do. Somewhere in this is deciding how difficult it is to learn new coding strategies against how much is lost doing it how I know.

I had not noticed earlier, but your question seems to assume that you will do this in VBA rather than using Excel's worksheet functions. I generally prefer worksheet functions myself over VBA, so I would ask if you are required to use VBA, or if you prefer VBA, or if you are interested in a worksheet formula approach.

Overview of a VBA approach: 1) Like you suggest use a block IF or a Select Case structure to detect those specific characters and determine the multiplier, followed (2) by a Replace() function that replaces the text with your decimal separator, followed by (3) multiplying the number by the multiplier. Step (4) is to put all of that inside of your desired loop structure.

A worksheet formula approach would do all of the same steps: 1) Nested IF() or a lookup function to detect the characters and return the appropriate multiplier followed (2) by a SUBSTITUTE()*multiplier step.

I guess at this point, you need to decide which programming language you prefer to use for this, and then we can help