Title | Description | |
TEXT Function – Basics | In this post, you will learn about the text functions in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/text-functions-in-microsoft-excel/’,’_blank’)”] |
Lower | In this post, you will learn to change texts into lower case in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-change-uppercase-letters-to-lowercase-in-microsoft-excel-2016/’,’_blank’)”] |
Title Case with PROPER | In this post, you will learn about PROPER function in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-change-the-uppercase-string-to-title-case-in-microsoft-excel/’,’_blank’)”] |
Text to Column Wizard | In this post, you will learn to split texts into columns in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/split-the-full-name-to-first-name-and-last-name-in-microsoft-excel-2016/’,’_blank’)”] |
Find Nth Occurence of Text | In this post, you will learn to find the occurrence of Nth text in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-find-the-nth-occurrence-of-a-character-in-a-string-in-excel/’,’_blank’)”] |
Merge Column3 | In this post, you will learn to merge columns in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-merge-and-combine-column-data-in-microsoft-excel-2016/’,’_blank’)”] |
Prefix/Suffix with CONCATENATE | In this post, you will learn about CONCATENATE function in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-add-prefix-or-suffix-to-range-of-cells-in-microsoft-excel-2016/’,’_blank’)”] |
Remove 1st and Last Character with RIGHT & LEFT | In this post, you will learn to Remove the first and last Character with RIGHT & LEFT in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-remove-the-first-and-last-characters-from-the-cell-in-microsoft-excel-2016/’,’_blank’)”] |
Remove Leading Spaces with TRIM | In this post you will learn to Remove Leading Spaces with TRIM in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-remove-leading-and-trailing-spaces-in-microsoft-excel-2016/’,’_blank’)”] |
Count Number of Words | In this post, you will learn to count number of words in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-count-number-of-words-in-excel-cell/’,’_blank’)”] |