Apply UCASE Function

**flindy87** · 07-08-2013, 06:43 AM

Hi all,

I am trying to apply UCase to a dim'd range, however i cant seem to get it to work.

Please Login or Register  to view this content.

Basically AWDID is the range of cells i need to apply UCase to. The bold bits are what i have added however that does not work.

Any suggestions?

**Debraj Roy** · 07-08-2013, 07:26 AM

Hi flindy!

Can you please
Instead of

Please Login or Register  to view this content.

try this

Please Login or Register  to view this content.

I think you want to use AWDID in somewhere else..

**flindy87** · 07-08-2013, 07:42 AM

Hi again Debraj,

Unfortunately that does not work

**AB33** · 07-08-2013, 08:02 AM

Basically AWDID is the range of cells.
I do not think you can apply to range of cells, but has to be on each cell.

**Debraj Roy** · 07-08-2013, 08:05 AM

Hi Flindy!

I guess, I was wrong.. you want to convert Column B's value to chopped item..

So if in B 12, old value was "KWILLIS1-K Willis", you not only wants to convert it to "K Willis1", but also wants to convert it to "K WILLIS1"

If above assumption is correct then try this..

Please Login or Register  to view this content.

if it doesn't solve your problem.. Please upload a small sample workbook.. with expected output.

**flindy87** · 07-08-2013, 08:24 AM

Please Login or Register  to view this content.

This works. Debraj, thank you again!

Apply UCASE Function

LinkBack

Thread Tools

Rate This Thread

Display

Apply UCASE Function

Re: Apply UCASE Function

Re: Apply UCASE Function

Re: Apply UCASE Function

Re: Apply UCASE Function

Re: Apply UCASE Function

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions