Hi,
I have 4000 records with special character"[]" in a sheet. I can replace "[]" this square box manually, but those are in 4000 rows. Is there any VB script which can replace this special character with "TAB" space. Please help me out
Thank you
Anil
Hi,
this code should help
Sub Replace ()
With ActiveSheet
Columns("E:E").Select
Selection.Replace What:="[]", Replacement:=""""
End With
End Sub
Of course you should edit the column references to suit your need and make sure you are in the sheet where you need the replacement when you run the macro
If you attach the spreadhseet, I can run it for you
Last edited by wakeupcall; 05-21-2012 at 12:11 PM. Reason: spelling mistake
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks