I have a large excel file that has a large amount of text in a specific cell (description) for every row (record).
the text is all uppercase. i can convert it to lower case in excel that is not the problem.
However, sometimes the cell contains information like
CARTRIDGE LEXMARK E198525BE 5000 PAGES.
I want the result to be :
Cartridge Lexmark E198525BE 5000 pages.
So starting with a capital for the string and all the rest lower case EXCEPT is there's a alphanumeric piece it should be in capitals (E198525BE in the example)
Can anyone give ma a macro of a formula for this ?