G
Guest
Hi I have using array formula
=COUNT(IF(('sheet1'!$C$4:$C$200="corporate")*('sheet1'!$L$4:$L$200="ip"),'sheet1'!$Q$4:$Q$200))
I want to trim all extra spaces in column c.
Please advise how to use trim function.
Thanks
=COUNT(IF(('sheet1'!$C$4:$C$200="corporate")*('sheet1'!$L$4:$L$200="ip"),'sheet1'!$Q$4:$Q$200))
I want to trim all extra spaces in column c.
Please advise how to use trim function.
Thanks