custom function to ucase first 2 letters

**lastnn30** · 03-04-2021, 03:18 AM

Hello, I want to create my own function which will take a text and convert the first 2 letter to upper case but this function is not working! Thank you.

Please Login or Register  to view this content.

**Kaper** · 03-04-2021, 03:58 AM

try

Please Login or Register  to view this content.

or shorter and working also with shorter strings
(deleted - see corrected version below)

**Kaper** · 03-04-2021, 04:06 AM

Note I removed second version form above post.
Here it is corrected:

Please Login or Register  to view this content.

custom function to ucase first 2 letters

LinkBack

Thread Tools

Rate This Thread

Display

custom function to ucase first 2 letters

Re: custom function to ucase first 2 letters

Re: custom function to ucase first 2 letters

Thread Information

Users Browsing this Thread

Similar Threads

Custom Format with Numbers and Letters?

[SOLVED] Apply UCASE Function

Excel custom format with letters and numbers

Custom sorting with Letters and Zeros

[SOLVED] How do I change letters at top of excel to custom headers

How do I change letters at top of excel to custom headers

How do I change letters at top of excel to custom headers

Bookmarks

Bookmarks

Posting Permissions