I paste in some external data and some of these data is —
How can i make it so that when I paste in the data into a cell that — get converted into 0?
I paste in some external data and some of these data is —
How can i make it so that when I paste in the data into a cell that — get converted into 0?
Paste as you did, then do a Find/Replace replacing "—" with 0 ?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Where is the data coming from?
Generally, you cannot remove stuff when pasting, you need to do that in another step, as Special-K suggested
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks