Bulk Replace Collection Items

lruijia

New Member
Hello :)

I am trying to manipulate either
  • a. Text data items in a collection
  • b. Data items in MS Excel
Other than using the replace function in the calculation stage and looping through the collection, is there a way to bulk replace a ' to be ''? Cannot seem to find a "find and replace" function in the MS Excel VBO.
 
Top