find string within a string

[kingweezerdude]

Guys-

A text file with many elements is placed in column A1.
I am interested in extracting the elements value and placing it in its appropriate cell.

Column A1
87LPP=5.00 87LP1 = 4.3 50PP1 = 0.67
50PD = 2 51PD = 3.00 79 = Y

for example, I'd like to find 87LPP in column 1, and put 5.00 into range G1. then find 87LP1 and put 4.3 into range G2, then find 50PP1 and put 0.67 into range G3.

The issue I am having is that sometimes spaces between the equal signs may be 1 or 2 or even 3 spaces between values. here's a snipet of code I've come up with, but it's not working entirely.

Your help would be much appreciated, thanks

Please Login or Register  to view this content.

[Mordred]

Hello kingweezerdude and welcome to the forum.

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

[kingweezerdude]

Hello kingweezerdude and welcome to the forum.

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

Thank you much for the tip, I got it fixed.