Forum Discussion
bradpeterson
Jul 21, 2020Copper Contributor
excel function replace all letters in document with numbers automatically
Hello, I'm in need of some help and I cannot find a solution online. I have a document that has uniform sizes. i.e. S, M, L, XL I need to replace those sizes automatically: S=1, M=2, L=3, xl...
NikolinoDE
Jul 21, 2020Platinum Contributor
Here ๐
hope I did nothing wrong ...
hope I did nothing wrong ...
Riny_van_Eekelen
Jul 21, 2020Platinum Contributor
NikolinoDE Don't really know what your intentions are, but you are certainly not responding to the issue in this thread.
- NikolinoDEJul 21, 2020Platinum ContributorHi Riny_van_Eekelen,
Are you sure about that?
As I understood it from the translation (I speak mainly German that does not mean that I canโt speak some other languages), you want to have columns in different widths with VBA.
That's exactly what I did, and at the same time I also showed an additional option.
Therefore I do not understand your suggestion.
Just try to help as far as I can, despite my ignorance ... because the principle is "help to be helped", so the helped can learn something new and who helped to gain some experience.
But as I said, do not want step anyone too close
and if I have disturbed anyone with my comments, please forgive me
... because there was certainly no intention.
Nikolino
Do not look for mistakes, look for solutions.
Henry Ford- SergeiBaklanJul 21, 2020Diamond Contributor
Nope, that's about mapping of clothes sizes (S, M, L, XL,...) to sequential numbers.
- NikolinoDEJul 21, 2020Platinum ContributorHi Mr. Sergei Baklan & Mr. Riny_van_Eekelen,
Now that Mr. Baklan has brought this to my attention, I have seen the mistake of mine.
I would like to apologize for my mistake to everyone involved ... who can read and googling has an advantage ... what I missed :-(.
Thanks again for the tip and sorry if I accidentally stepped on the wrong foot, it was definitely not my intention ... as I said "help to be helped".
Have a nice day and thank you for your attention :-).
Nikolino
When i know that i don't know, when does i know when i know something?
- SergeiBaklanJul 21, 2020Diamond Contributor
Perhaps English<->German translation is very approximate