troubleshooting Question

change case in excel of alphanumeric text using a macro

Avatar of ggc2
ggc2 asked on
Visual Basic Classic.NET ProgrammingMicrosoft Excel
8 Comments1 Solution199 ViewsLast Modified:
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 ?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros