Need formula to flip or mirror letters

[Jack-P-Winner]

I have a lot or rows of U's, D's E's and O;s I want to flip or mirror image. How can I wrote a formula to do this automatically. Basically if I have a U in C:2 and I want to mirror and change to a D, if there is a E I want it to mirror a O.

So U=D and E=O

I am using this formula to extract them from columns CDEFG =CONCATENATE($C3,$D3,$F3,$G3)


Thank you!!!

 

[NARAYANK991]

Hi Larry ,

You need to be a little more specific.

What do you want to mirror ? The single column of formula results ( column K ) , or the 4 columns of data ( columns C , D , F , G ) ?

If it is the 4 columns , where do you want the mirror values ?

Narayan

 

[Luke M]

Assuming it's just columns K and AA
in O3:
=IF(K3="U","D","U")
in AE3
=IF(AA3="E","O","E")

 

[Jack-P-Winner]

Assuming it's just columns K and AA
in O3:
=IF(K3="U","D","U")
in AE3
=IF(AA3="E","O","E")

Thanks Luke, I can adjust the columns as needed thanks to you!!!!!!

 

[Jack-P-Winner]

Luke,

This may sound like redundancy (it's not) but how can I write this to incorporate it into the 4 columns in the spreadsheet for example CDFG? Once you write the formula I can adjust where I need to

As ALWAYS, THANK YOU!!!!!

 

[srinidhi]

nested ifs. see the second tab

 

[Jack-P-Winner]

nested ifs. see the second tab

Thank you so much srinidhi!!!

 

[srinidhi]

Glad to have helped you.....