Change the last 3 characters in a cell to Uppercase

[TravelMI]

Hi all,

I need a formula in Excel that will allow me to get the below format with the last 3 characters in a cell to be uppercase whilst everything else can be lower or remain as it is as currently all text is lowercase.

Any responses greatly appreciated.


[TABLE="width: 500"]
<tbody>[TR]
[TD]Existing format[/TD]
[TD]Required format[/TD]
[/TR]
[TR]
[TD]ccooperbfp[/TD]
[TD]ccooperBFP[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thank you!

C

 

[pgc01]

Hi

Try:

=LEFT(A1,LEN(A1)-3)&UPPER(RIGHT(A1,3))

 

[AliGW]

Or this:

=SUBSTITUTE(A1,RIGHT(A1,3),UPPER(RIGHT(A1,3)))

 

[pgc01]

Hi Ali

If the last 3 characters of the string appear somewhere else it will not work.

For ex.

abcdabcd

results in

aBCDaBCD

 

[TravelMI]

Hi pgc01.

Thank you, that works perfectly.

 

[pgc01]

You're welcome.