Hello All
I have a spreadsheet with a number of text strings in Col A and would to extract data from them and put it in a number of other Columns as follows
1.Time at the begining of the string - insert in Col E
2.If text contains "Hurdle"- Col Q insert "HDL"
If text contains "Chase"- Col Q insert "CHS"
If text contains "National Hunt Flat"- Col Q insert "NHF"
If text contains none of the above - Col Q insert "FLT"
3.If text contains "Handicap" or "H“cap" Col R insert "HCP"
If text does not contain "Handicap" Col R insert "STKS"
4. If text contains "Novice"- Col BI insert "NOV"
If text contains "Maiden"- Col BI insert "MDN"
If text contains none of the above - Col BI insert "NOT"
5. Class number insert to Col O
6. Distance (found at the end of the text) insert to Col N
7. Winner amount without the comma or £ sign to Col M
(if possible rounded to 500 using the MROUND function)
Col A will then be removed and the days date inserted.
The data will be used every day so a macro would be ideal,I have attached a spreadsheet showing the required data,which i hope will explain it better.
Many thanks for help given.
Bookmarks