Saturday, October 27, 2012
Tuesday, October 23, 2012
excel: last index of
assuming that text is in cell A1, and we are looking for "\" character, this works: =SEARCH("@",SUBSTITUTE(A1,"\","@",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))))
from here.
from here.
Sunday, October 21, 2012
Saturday, October 20, 2012
Wednesday, October 17, 2012
Monday, October 15, 2012
Monday, October 08, 2012
excel: lovely keyboard shortcuts
very simple, but oh so useful:
- shift-space: select row
- control-space: select column
Monday, October 01, 2012
Subscribe to:
Posts (Atom)