find replace
Space.xlsx
when i trying to find replace this space its not replace after AVE & before TUCS please help me to find replace with Alt + 0010 & 0013 but its not work I was check in xp then its show under square question mark
for check try edit C7 by arrow key its stop between AVE & TUCS
when it copy paste it show like up down
AVE
TUCS
like this please help me thanks in Advance ...
CTRL + H
Find (space)
Replace by (leave blanc)
Changes
AVE TUCS
into
AVETUCS
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi Dear oeldere
this space i cant copy or paste in CRTL + H on my PC
copy paste not work because its a symbol & its show like under square question mark.
You actually have 2 funky characters in there 13 and 32. This will remove them, put it in a helper...
=SUBSTITUTE(SUBSTITUTE(C7,CHAR(32),"",1),CHAR(13),"",1)
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
thanks Ford
its work
Glad it worked for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks