Hello. I need to extract a $ value out of a text string in A3 and move it to F2, so on and so forth, for the entire worksheet. I have included sample data in the attached file.
Thank you!
Hello. I need to extract a $ value out of a text string in A3 and move it to F2, so on and so forth, for the entire worksheet. I have included sample data in the attached file.
Thank you!
Last edited by ADHowie; 10-27-2010 at 04:58 PM.
Hi, sorry for the bother. Someone showed me how to use a basic mid formula to do what I needed.
try :-
=SUBSTITUTE(LEFT(A3,FIND("@",SUBSTITUTE(A3,",","@",LEN(A3)-LEN(SUBSTITUTE(A3,",",""))))-1),LEFT(A3,FIND(":",A3)+1),"")
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
If you need it, it allows for income being <100,000 !
Hi squiggler47, thank you for that formula. It worked just as well as the MID formula that my other friend suggested. I appreciate your help and quick response!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks