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))
In Excel 2002 & Excel 2003, this problem is solved in the following manner:
1. In Step 3 of 3 of the Text Import Wizard, or in Step 3 of 3 of Text to Columns (select from Data), click Advanced.
2. In the Advanced Text Import Settings dialog box, select the Trailing minus for negative numbers checkbox.
Screenshot // Problem: The Minus Sign Appears to the Right of the Number
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.
To remove the minus sign I select the entire column & find for "-" & Replace with none" ".Is not a easy way?
To delete extra spaces use the Trim function brfore using the formula offer here.
Problem being that the minus sign might mnot be fuly right aligned, say if it has a space after it, what then?