LinkBack URL
About LinkBacks
hello
i want to remove $ sign form a range A4:A50
i have data in Range A4:A50
$H$2
$H$2
$H$2
$H$2
$H$2
$H$2
$H$2
.....continue
i want to remove atone the $ Sign
thanx
hello
i want to remove $ sign form a range A4:A50
i have data in Range A4:A50
$H$2
$H$2
$H$2
$H$2
$H$2
$H$2
$H$2
.....continue
i want to remove atone the $ Sign
thanx
Use Find/Replace
find $ replace with nothing
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
hello Mod
thanx alot
find and replace is useful
but i want to remove $ sign only selected range
Highlight the range you need to use 1st, then use F/R
hello Mod
if i selecting range and use F/R then click replace all, all sheets $ sign is replacing
So does this mean that in range A4:A50, you want to have...Originally Posted by haroon2015
H2
H2
H2
H2
H2
H2
H2
If so, then highlight A4:A50 and try my suggestion
If this still does not work, upload a sample
hey Mod
thanx a lot now working but one by one entry is replacing
but it will do
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks