Lower case for long string but not first digit....

[b_garside]

I need to make sure the ones in green are lower case whiel skipping the Q.

I know its a nested fuicntion but not sure how to skip the first letter. total lenght is 37 digits including Q

Qc66e8037_1eb2_4b16_9b6d_18c9f2b44d73

[swuehl]

Look into the Lower() function.

and if you want to remove the first char, try mid(TEXT,2, 36).

So maybe combined like

=lower( mid( 'Qc66e8037_1eb2_4b16_9b6d_18c9f2b44d73', 2, 36))

[b_garside · Accepted solution]

I ended up doing this since the Q cant be left truncated I just add back on once the string is lowercase.

'Q'&Lower( Mid('Qc66e8037_1eb2_4b16_9b6d_18c9f2b44d73'),2,36) )

[b_garside]

Thank you, I needed the Mid fucntion I was missing that..

[swuehl]

I think you can simplify this to

Capitalize( 'Qc66e8037_1eb2_4b16_9b6d_18c9f2b44d73')