Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing hard returns in long text strings.
I thought I knew how to do this, i.e. put ALT+0010 in the find box, replace
with something else. However when I try and do this in a file which contains a lot of very long text strings (the first one is 5000 characters, the largest nearly 10000), it doesn't work. Even if I try to replace "a" with "b", it tells me "Formula is too long", and stops the replace function dead in it's tracks. (this even though the field is not a formula) I can copy an individual string to Word, and replace "manual line breaks" - that works. However, I've got hundreds of these strings, and it has to be done on a regular basis, so that isn't a viable option. Any suggestions very welcome. Thanks, Geoff. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hard returns | Excel Discussion (Misc queries) | |||
Excel wildcard ? for replacing strings in dropdown function | Excel Discussion (Misc queries) | |||
Replacing a hard line break in Excel | Excel Discussion (Misc queries) | |||
Replacing characters in numeric text strings and SUMming | Excel Discussion (Misc queries) | |||
Filter long Text strings | Excel Worksheet Functions |