Extract Line of Text w/ specific characters up to the paragraph character, send to Excel

dmarie123 · #3 07-16-2015, 09:49 PM

Hi Paul,

I was hoping you'd be the one to post. The last "x"s represent the ID number assigned by the state. The ID number that contains the 1507 prefix seems to be a standard length in all the reports I've seen so far but I don't know if the number of characters would change if all of a sudden there was a surge in corporations for that day.

After that number there are three blank spaces before the corporation name. At the end of every line containing the above there is a return. I wasn't sure if it was possible to find a prefix and then somehow search to "the end of the line".

Donna

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to insert paragraph character after every 500 characters?	aditya_bokade	Word VBA	28	11-13-2021 10:48 PM
Macro to Insert text into the beginning on specific paragraphs unless the paragraph is blank	caboy	Word VBA	2	04-01-2015 07:00 AM
How can select from a specific character to another character	mohsen.amiri	Word	2	02-19-2015 11:38 PM
Replace paragraph-marks (line-breaks) in tables with a character-string	Aztec	Word VBA	2	04-02-2013 10:52 PM
How to import a text file but skip the first line regardless of characters?	omahadivision	Excel Programming	7	02-01-2013 08:30 PM