V
vselin1
Hi -
We downloaded an excel spreadsheet with about 4000 rows of different text
and about 10 different colums of text. One of the colums contains either
short amounts of text or large amounts of text that include basic html such
as <br>, <li>, etc.
Instead of using the "find and replace" tool...which allows you to change
about one sentence at a time for another one.....is there a way to change
whole paragraphs? "Find and replace" is great....but the amount of text you
can place in it is limited. We would like a tool that allows us to replace 5
or 6 sentences at a time.
Any thoughts on how to do this....or any 3rd party tools that would do this?
Also...many times we get the "formula is too long" error message....we don't
know what this means and when we get it, we are not able to change the text
in that cell with the "find and replace"....if anything.....how do we advoid
getting this message....if we had to i guess we could change a sentence at a
time with the "find and replace".....but it's not allowing us to get past
that point.
thanks everyone!
We downloaded an excel spreadsheet with about 4000 rows of different text
and about 10 different colums of text. One of the colums contains either
short amounts of text or large amounts of text that include basic html such
as <br>, <li>, etc.
Instead of using the "find and replace" tool...which allows you to change
about one sentence at a time for another one.....is there a way to change
whole paragraphs? "Find and replace" is great....but the amount of text you
can place in it is limited. We would like a tool that allows us to replace 5
or 6 sentences at a time.
Any thoughts on how to do this....or any 3rd party tools that would do this?
Also...many times we get the "formula is too long" error message....we don't
know what this means and when we get it, we are not able to change the text
in that cell with the "find and replace"....if anything.....how do we advoid
getting this message....if we had to i guess we could change a sentence at a
time with the "find and replace".....but it's not allowing us to get past
that point.
thanks everyone!