I have a formula which I need to be able to copy/paste to a "Save As" file
name.

Column A Column B
R1 Prod LP10
R2 DivOp1 PUA
R3 14
R4 M
R5 1

Formula is =Prod&"-"&DivOpt1&"-"&B3&B4&B5

The formula returns "LP10-PUA-14M1".

This is supposed to be the name for a file. Yet I cannot copy this result
and paste the name in the "Save As" file name. I've tried Text, T, and a few
others.

Any alternatives to solve this problem?
End result as text is supposed to be "LP10-PUA-14M1"