IF cell A1 contains 'H' then insert 'A' into cell B1 if it does not.......

[AJW1100]

IF cell A1 contains 'H' then insert 'A' into cell B1 if it does not then do nothing.
The above reverse
IF cell A1 contains 'A' then insert 'H' into cell B1 if it does not then do nothing.
This is for Home and Away matches that reverse each year, one year it's a Home game the next year it's an Away game. I can then easily reverse them, copy the results and paste in C as values, then delete A and B columns. I hope that's right!

 

[johnnyL]

How about a formula for Column B:

=IF(A1="H", "A", IF(A1="A", "H", ""))

 

[AJW1100]

Thank you for your help, due to a sudden problem I have not been able to test it out on my spreadsheet, but I am sure it will do what I need.

 

[johnnyL]

Glad to help, Let us know if you have any issues.