Macro for lower cases without using a loop

**MaartenRo** · 08-15-2022, 05:31 AM

Hi,

I have a column With 30,000 rows and i would like them all te be in lower case characters.
How can this be done without a loop?
I used this macro, but it takes an endless amount of time.

Please Login or Register  to view this content.

**jindon** · 08-15-2022, 05:47 AM

Please Login or Register  to view this content.

**MaartenRo** · 08-15-2022, 08:22 AM

Thank you!

Macro for lower cases without using a loop

LinkBack

Thread Tools

Rate This Thread

Display

Macro for lower cases without using a loop

Re: Macro for lower cases without using a loop

Re: Macro for lower cases without using a loop

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to adjust code to include all cases of text lower and upper

[SOLVED] Formula needs to compare cases (upper/lower) of FIRST LETTER and update words correctly

Excel auto upper cases certain words even though it was changed to lower case

Loop through different cases from a IE page

Do While loop--how to I loop (skip certain cases)

[SOLVED] Upper and Lower Cases of Text

How to skip special cases in a For Each loop

Bookmarks

Bookmarks

Posting Permissions

Macro for lower cases without using a loop

Re: Macro for lower cases without using a loop

Re: Macro for lower cases without using a loop

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to adjust code to include all cases of text lower and upper

[SOLVED] Formula needs to compare *cases* (upper/lower) of FIRST LETTER and update words correctly

[SOLVED] Upper and Lower Cases of Text

Bookmarks

Bookmarks

Posting Permissions

[SOLVED] Formula needs to compare cases (upper/lower) of FIRST LETTER and update words correctly