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...
Riny_van_Eekelen
Jul 21, 2020Platinum Contributor
NikolinoDE ??
NikolinoDE
Jul 21, 2020Platinum Contributor
Here 🙂
hope I did nothing wrong ...
hope I did nothing wrong ...
- Riny_van_EekelenJul 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.
- SergeiBaklanJul 21, 2020Diamond Contributor
Perhaps English<->German translation is very approximate