Unnecessary Blank Characters in Cells in Excel 2010

In this article we will learn how to delete the unnecessary blank character from a cell, we will use “TRIM” function in Microsoft Excel 2010. TRIM...

The Minus Sign Appears to the Right of the Number in Excel 2007

To move the minus sign from right to left: Use the following formula: =VALUE(IF(RIGHT(A1,1)="-",RIGHT(A1,1)&LEFT(A1,LEN(A1)-1),A1)) Or 1. ...

Importing a Text File in Excel 2007

To import a text file: 1. Select File -> Open -> find the text file and click Open. 2. In Text Import Wizard dialog box: Step 1: Select De...

Problem: Values Not Formatting as Numbers

Option 1: Change the column formatting from Text to General by multiplying the numbers by 1: 1. Enter the number 1 into a cell and copy it. 2. Sel...

Problem: Date Formatting Cannot Be Changed

To change the formatting from Text to Date, use Text to Columns technique: 1. Select the column formatted as text. 2. From the Data menu, select T...

Problem: The Minus Sign Appears to the Right of the Number

To move the minus sign from the right to the left: Use the following function: =VALUE(IF(RIGHT(A1,1)="-",RIGHT(A1,1)&LEFT(A1,LEN(A1)-1),A1)) ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube