Office Tips and Tricks
Word:Convert Texts into a Table:
Visio: Find & Replace
Excel:
Formula- Convert a text to Number:
=VALUE(TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," "))))Formula - Search a Column of Strings Based on Datas in another Column:
=MATCH("*"&(O6)&"*",B:B,0)
Automatically Add Column Titles on Each Print Page:
Set Tables Border:
Reference:
1. Excel Tips Net2. Excel Formula : Convert a text to Number
3. Excel Formula: Search a column of strings in the spreadsheet