Hello,
I have VBA formula and I need to add If & IsError due to empty cells, I have tried
"=If(ISERROR(LEFT(RC[-1],FIND("", "",RC[-1])-1)),"",LEFT(RC[-1],FIND("", "",RC[-1])-1))"
But not working
Thanks for any help on this
Sub SplitColumn()
Dim ws As Worksheet
Set ws =...