Lots of Excel text
Lots of Excel text
- Subject: Lots of Excel text
- From: Hanaan Rosenthal <email@hidden>
- Date: Mon, 18 Jul 2005 16:50:28 -0400
- Organization: Custom Flow Solutions
Hi,
I have a problem with Excel that requires me to take a whole bunch of text
from an Excel cells and do the following:
1. Combine two or more cells (each has 30000 characters, other than the last
one that has less).
2. Search and replace text in the combined string.
3. Split the text back to 30000 character blocks.
4. Place each block back in cells A1, B1, C1...
I can't use copy/paste of set value since these are limited in size.
Any suggestions?
I tried a bunch of export/import tests and got close...
I can export the worksheet as text, combine it, search and replace and re-
save to text.
Placing the long chunks of text in Excel is the big issue.
Ideas?
Thanks,
Hanaan
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden