Monday, 23 September 2013

Question: How to remove white space from a number in excel?

Sometime we got the data in excel sheet in number format which contain space as 1000 separator. This format could cause the problem if you use those excel data further as number in data upload process. In data upload process SSIS package will not work because of set up rules. So at that time we need to remove black space between the numbers. For that follow the below steps -

Step 1 -  Copy the space only after select.
Step 2 - Use substitute method in excel as below screen shot -

Note : In the substitute method, space should be copied(ctrl +C).
I hope this will solve the problem.

Let me know here if anyone have better answer.

No comments:

Post a Comment