Category: Texts and Strings

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...

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...

Enter a zip code, and Excel will tell you in which state it is It also has a list of all zip codes for all...

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...

Here you will see how to work with functions to insert a blank row every certain number of rows in a table using a blank...

This one is very similar to Tally chart, however, it is for another purpose. It is used to draw a progress bar, yes a progress...

Using a single function can make a graphical view to your number Function is REPT along with IF and INT to show that number in...