Community

Your solution worked perfectly, Thank you. And it didn't solve the problem, excel still chokes even though I'm no where near it's row /column limitations.

Hi, and thanks in advance. I'm importing text into excel 2007 and getting file too large errors, even though I don't exceed the column or row limitations. So, how can I delete all characters in a line beyond character number 1662?

Thanks Mudguard, that worked quite well.

Hi, and thanks in advance for your help. I'm editing some huge medical records for a hospital and I have to remove variable length strings of characters from the cursor up to a specific text string, and leave the string intact.

Okay, I figured it out.

Okay, I figured out the asterisks are the problem. How do I make them asterisk instead of wildcards? Thanks.

Hi, thanks in advance for the help. I have some text where the columns don't align correctly and I need to insert 227 spaces.

*** CONTINUATION *** NOTE #1

between the trailing asterisk and the "NOTE", is where I need the spaces inserted. If I just type in spaces textpad says invalid expression ...

Thanks Bob! This worked - ^ \* \*.*\n
I just needed to know how to handle the *. Kevin

I have a line of text that repeats on a couple of hundred lines. It starts with * * * * * * * * * * I N S U R A N C E D A T A * * * * * * * * * *
Every replace I try deletes every line in the whol;e document (wildcard). Any thoughts? Thanks, Kevin

Ben, first - thank you for your time in responding to my problem. My goal is to search for a text string, search for another text string and then select and delete all data between the two text strings. I don't mind recording a macro, but because the data between the two text strings will vary in ...

Hi Ben, your assumption was correct...I meant to delete the lines of text. I know how to run the searches, but how do I select the text between and delete it? Thanks!!

I have to format about ten thousand lines of account information for an Excel import. I need to anywhere from one line of text to ten lines of text that occur in every account. There are unique phrases before and after the text I need to delete. Thanks for your help in advance.