by Ilker | Apr 9, 2018 | Excel Tips & Tricks
One perfect example of automatically cleaning up data in Excel is when working with name fields. You can separate first and last names (or actually any text with spaces) using this method. Syntax =LEFT(Full name, FIND(” “, Full name) – 1) Steps Begin by...
by Ilker | Apr 6, 2018 | Excel Tips & Tricks
You can easily count the number of characters inside a cell using the LEN function. This function can be especially useful when identifying data types or creating validation rules. Syntax =LEN(text) Steps Begin by typing in =LEN( Select or type in the range reference...
by Ilker | Apr 5, 2018 | Excel Tips & Tricks
Excel’s Search and Find feature is very helpful when looking up things in workbooks, but this means searching for keywords one by one. SEARCH and FIND are formula versions of this very handy feature and can work wonders in large data sets. Syntax...
