Excel Char

How to Add Quotes around Cell Values in Excel

This post will guide you how to add double quotes around cell values with a formula in your worksheet in Excel. How do I add quotes around each value of cells in Excel 2013/2016. How to add double quotes inside a formula in Excel. Assuming that you have a long list of names that need… read more »

How to Warp X-Axis labels in Excel

This post will guide you how to wrap the text of x-Axis labels on Excel Charts. How do I wrap x axis labels in a chart in Excel 2013/2016. Warp X Axis Labels Assuming that you have created a column chart with relatively long labels on X axis the program by default puts the label… read more »

How to Remove Specific Character from Text Cell in Excel

This post will guide you how to remove a specific character from text cell in Excel. How do I remove certain character from a cell with a formula in Excel 2013/2016. Remove Specific Character Using Find and Replace function Remove Specific Character Using Formula Assuming that you have a list of data in range B1:B5,… read more »

How to Concatenate Data with a Line Break in Excel

This post will guide you how to combine multiple cells with line break in Excel. How do I concatenate cells with a line break character into one cell with formula in Excel. Concatenate Data with Line Break Character You can use CONCATENATE function to combine multiple cells or rows into one cell in Excel. And… read more »

How to Remove Line Breaks (Carriage Returns) in Excel

This post will explain that how to remove line breaks in your data set in Excel. How do I remove carriage returns or line breaks with a formula in Excel. How to remove line breaks with VBA Macro in Excel. How to remove line breaks with find and Replace feature in Excel 2010/2013/2016. Remove Line… read more »

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