Find and replace error
I have a worksheet that was created by pasting in data from a word table. I
am in the process of cleaning up the data which will in turn be used to
populate a database. As part of my clean up I am using the find and replace
function to take out commas. Some of the text is lengthy. When I get to a
lengthy cell, Excel is giving me an error stating that the formula is too
long.
Thoughts? Work arounds?
Thanks,
Michelle
|