Spaces from cell !

[avinashraste]

Dear Friends,

I have a few rows & columns in a sheet where some cells contains the content from other sheet also. When I copy these content, and paste it in notepad, it gets pasted with a space of a "Tab" where as I want a simple & single space. someplace I want it after the word / number in a cell & some place I want it before the number / word in a cell.

Can someone please suggest a solution ?

Thanks in advance,

AR

 

[psulions83]

Are there spaces in the excel data?

 

[avinashraste]

No...! There is no spaces in the data in cell...!!! But please suggest any solution if I want to add a single space instead of the space of a "Tab"

Regards,

 

[psulions83]

I think with an upgrade version of notepad this can be handled differently. But if using Notepad you could copy data from excel, paste into notepad, copy one of the tab spaces, press CNTL+H and paste, then replace that with a space. Then finish with replace all. Hope that works.