Require to revoke beginning hyphen

[ExcelUser2707]

HI GURUS,

Please help

I am facing problem of hyphen, it is at beginning (random) of all cells. Right now I am using formula =SUBSTITUTE (TARGET CELL,CHAR(160)," ")+0.

There is any other solution to convert data in easy way.

Sample sheet is attached here for your reference test 0.99.xls

Thank You,

Amar K

[Debraj Roy]

Hi Amar..

What is the password or secret process.. to view the "HYPHENS" in the attached.. which we need to remove..

[ExcelUser2707]

HI Debraj

Thanks for your reply. I didn’t set any password to file.

New copy of the same was uploaded as test. 0.999.

Require removing hyphen coz, I can’t use this type of material at formula level, and pivot.

Thanks

[Debraj Roy]

Select Column.. and use Text to Column..

Next Next Finish..

Will work the same as REMOVING NBSP non-visible space.. which is Char(160)

[ExcelUser2707]

Thanks Bebraj,

It was worked very well. But I have more than 19 columns and the interval of date to execute and restructure twice in a week.

As Microsoft excel will not allow to convert multiple column, it will take time to routinze the data.

Thanks for sharing valuable information.

If any other shortcuts to do this please revert.

[jindon]

There is no Char(160).

Run the code

Please Login or Register  to view this content.

[ExcelUser2707]

Hi Jindon.

Your code works successfully, thanks for sharing valuable information.

Your knowledge is appreciable.

Thanks

Amar K