upobDaPlaya
asked on
How do I remove a # from a string
If I want to loop thru Column A in my Excel spreadsheet and remove # from all strings found in Column A then how would I do this ? I found a function called Application.Substitute that may work, but I am fuzzy on how to set the range for just Column A and loop thru Column A to remove #. In addition I am unsure if the Application.Substitute is the best approach ?
Thoughts, suggestions ?
Thoughts, suggestions ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for everyones input
Note that this method may change items from text to number formats.