Excel Char

Generate Random Character Strings

This post will guide you how to generate a random character string in excel. How do I create a random passwords, text strings with a formula¬†in excel. How do I generate random strings of characters with VBA code in excel. How to generate random alphanumeric values in excel. Generate Random Character Strings with Formula To… read more »

Concatenate columns with Line Breaks (Alt + Enter)

This post will guide you how to combine multiple cells in one or more columns into one cell with line breaks or Alt +enter in Excel. How do I concatenate different values together into one cell with line breaks. For example, if you are trying to combine three cells (B1,B2,B3) into one(C1) with line breaks… read more »

Remove Leading and Trailing Spaces

In this tutorial you will learn that how to remove leading or trailing spaces from a text string in a cell in Excel. This post will guide you how to delete leading or trailing spaces of all cells in a column. If you remove leading spaces in cells one by one by manually, it will… read more »

Generate Random Passwords

This post will teach you how to quickly generate a random password with Formula in Excel. You can combine a series of worksheet functions to create a complex formula to generate a random password in Microsoft Excel. Generate Random Password Normally, a secure password should have 8 characters at least and contain a mix of… read more »

How to remove unwanted characters from text string

This post explains that how to remove unwanted characters from text string in a Cell in Excel. How do I remove unwanted characters from a cell using Excel formula. Remove Unwanted Characters If you want to remove unwanted or specified characters from a text string, you can create an excel formula based on the SUBSTITUTE… read more »

How to count the number of line breaks in a cell

This post explains that how to count the number of line breaks in a cell using excel formula. How do I count line breaks in a single cell in excel. In the previous post, we talked that how to count specific words in a cell and this post will guide you how to count line… read more »

How to Split Multiple Lines from a Cell into Rows

This post will guide you how to split multiple lines from a cell into separated rows or columns in Excel. You will learn that how to extract text string separated by line break character into rows in excel 2013. In the previous post, we talked that how to split text string by only one line… read more »

How to Combine Text from Two or More Cells into One Cell

This post explains that how to combine text from two or more cells into one cell in excel. How to concatenate the text from different cells into one cell with excel formula in excel. How to join text from two or more cells into one cell using ampersand symbol. How to combine the text using… read more »

Split Text String by Line Break in Excel

In the previous post, we talked that how to split text string by a specified character in excel. And this post will guide you how to split text string by Line Break character. The difference is that you can type the line break character directly in the FIND function and you have to use the… read more »

Excel CHAR Function

This post will guide you how to use Excel CHAR function with syntax and examples in Microsoft excel. Description The Excel CHAR function returns the character specified by a number (ASCII Value) The CHAR¬†function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The CHAR function is available in… read more »

Sidebar