Excel Char

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 »

Sidebar