Hi All,

Below is the sample info where u can see i have few numbers in A1 to F1 rows.

A1 B1 C1 D1 E1 F1 G1
1 2 1 0 1

I'm looking for formula where if i try to type any number in G1 then previous cells values from A1 to F1 should be replaced with "L"
if any cell is blank no change, can any one help me on this.


TIA