Cuts string of list of items
An old lesson to one of my early classes to show how can we cut a string having list of items into its parts. (At least 1st three parts) using …
An old lesson to one of my early classes to show how can we cut a string having list of items into its parts. (At least 1st three parts) using …
Detect which cells has additional spaces added by mistake by user. =IF(AND(Left(F2, 2) = “No”, LEN(F2) >2, “Space at end”, “”)
Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats.
I have been in a lot of situation needing to convert a number came out from a string into actual numbers. Sometimes N() worked, sometimes not, others VALUE() worked, but …
Excel already has the formula ROW() =Row() Which as we may already know will give us the number of the row we are in, if you add no parameters However, …
This is the iframe in Excel, if you are familiar with the HTML concept of iframe, you will understand this one right away, it is basically the same project as …
Convert US addresses from cells (one column with 1 line for Name, 1 line for address, one line for City, State and Zip code) into table Now, say you have …