Using LEN, need some help altering the length of string it returns

[JonSwed]

Hi all!

I have a formula I'm using to create a new column where the first letter of a string is made upper case.

Looks like this:

Region rewrite =

(

(UPPER( left([Website region],1) ))

&

(right ( ('Site appearance'[Website region]), LEN( ('Site appearance'[Website region]) ) ) )

)

But this returns 'Jjordan'. What I need is 'Jordan'. I've been trying to use -1 to alter the LEN function but without success, any help much appreciated thanks!

[nandukrishnavs · Accepted solution]

@JonSwed 

Try this 

Region rewrite = 
(
     ( UPPER ( LEFT ( [Website region], 1 ) ) )
        & (
            MID( 
                 ( 'Site appearance'[Website region] ),2,
                LEN ( ( 'Site appearance'[Website region] ) )-1
            )
        )
)

[amitchandak]

@JonSwed , Try like

Region rewrite =
(
(UPPER( left([Website region],1) ))
&
(right ( ('Site appearance'[Website region]), (LEN('Site appearance'[Website region]) -1) ) )

)