K
KrispyData
I want to create a formula that states: if cell in columnA ends in (L) then
show result in ColumnB as Local.
sample data:
ColumnA
1.Wow Widget Store (L)
2.Widgets N More
3.Major Widget Store (L)
4.Allstar Widgets
I tried using the following formula:
if(A1="*(L)","Local","no)
Excel will not accept that. Any suggestions?
show result in ColumnB as Local.
sample data:
ColumnA
1.Wow Widget Store (L)
2.Widgets N More
3.Major Widget Store (L)
4.Allstar Widgets
I tried using the following formula:
if(A1="*(L)","Local","no)
Excel will not accept that. Any suggestions?