VBA search for value and insert space two characters to the right

VBA search for value and insert space two characters to the right

First of all a friendly hallo to all Forum members.

Ok I've got about 20000+ lines of data that look like this:

NODE S1 S2 S3 SINT SEQV
1 -0.90520E-02-1.3410 -2.1393 2.1302 1.8640
2 0.77851E-02-0.92696 -1.9901 1.9979 1.7314
3 -0.34783E-01-1.1249 -2.0717 2.0370 1.7655
4 0.36477E-01-0.93091 -2.0064 2.0429 1.7700
5 0.83489E-02-0.92708 -1.9901 1.9985 1.7319

And I want to insert a space behind "E-XX" so it will look something like this:

NODE S1 S2 S3 SINT SEQV
1 -0.90520E-02 -1.3410 -2.1393 2.1302 1.8640
2 0.77851E-02 -0.92696 -1.9901 1.9979 1.7314
3 -0.34783E-01 -1.1249 -2.0717 2.0370 1.7655
4 0.36477E-01 -0.93091 -2.0064 2.0429 1.7700
5 0.83489E-02 -0.92708 -1.9901 1.9985 1.7319

At the moment the VBA code looks somewhat like this:

Please Login or Register  to view this content.

But unfortunately it has two major drawbacks. It is inefficient and thus quite slow and I have to edit the code every time I apply it to a new set of data depending on the number of lines.
So my ides for improvement are the following.

Find "E-" and insert a " " (space) two characters to the right of "E-"

and

No=(value in a specified cell)

Unfortunately my web based research hasn't been to successful and all problems I found that were similar to mine were solved with code that is way out of my novas league.

Any suggestions or help?

Thank you for your time!

the TUGuys

fast as lightning:

Please Login or Register  to view this content.

Lets say E-** goes from E-01 to E-99 could one do the following?

Please Login or Register  to view this content.

Thanks again!

Greetings the TUGuys

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here