Here is my formula
=IF(LEFT(A1,13)="Game# 1 MSSP ",'M-Super-Pot(1)'!$E9&$AB2,"")
Right now $E9 value & $AB2 Value are crunched together want to add a few spaces in between them.
How can I code this up? Hmm another & before the last one but
&" "$AB2? Not sure how to code it up
thanks for your Help
=IF(LEFT(A1,13)="Game# 1 MSSP ",'M-Super-Pot(1)'!$E9&$AB2,"")
Right now $E9 value & $AB2 Value are crunched together want to add a few spaces in between them.
How can I code this up? Hmm another & before the last one but
&" "$AB2? Not sure how to code it up
thanks for your Help