Excel Formula

[something68]

Two part question:

D8 shows "H" and D9 shows "8"
E8 shows "MO" and E9 shows "8"
How can I have column V8 show "8", "8"?

AND

D8 shows "s" and D9 shows "8"
E8 shows "SF" and E9 shows "8"
How can I have column R8 show "8" and Column U8 show "8"?

 

[Pete_UK]

Is there any particular relevance as to what D8 and E8 contains?

Do you want R8 and U8 to show whatever is in D9 and E9, irrespective
of D8 and E8, or only if they contain the values "s" and "SF"
respectively?

I'm a bit confused.

Pete

 

[Luke M]

What is the point/value of D8 & E8? (why mention them?)
1) In V8, input:
=D9&", "&E9

2) In R8
=D9
In U8
=E9