I have data that is copied form a web based program and pasted into a excel spread sheet for printing.
The data is reduced with some find and replace code before printing, my problem that I am trying to solve is some of the data comes in the format of for example [Sick Leave] which is then replaced with Sick Leave.
Is there a find and replace code that can remove the [ ] brackets from any data that exists on the sheet.
Below is part of the code I am using to acheive results currently, I am hoping to have a bit of code that can remove the [ ] brackets and leave the Sick Leave.
PHP Code:
Selection.Replace What:="[Sick Leave]", Replacement:="Sick Leave", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Thanks for any advice