Recent content by Mohammed123

Formula did not work Hi The formula did not work for me as I want to take out “Business plan 2318” I want to separate the information between “on” and the first bracket. Information is all in the following format Audi A4 on Business plan 2318 (12 Month). 10000 Miles. ¶œ60.00 Insurance BMW...

I want the line to say the plan e.g. “Business plan 2318” there is also a list of plans if this helps. The content of the field offer is “Audi A4 on Business plan 2318 (12 Month). 10000 Miles. ¶œ60.00 Insurance” The table the field is being pulled from is called “Lease cars” I used the...

Hi Can someone please explain the what the following expression means cause i need to as i need to edit it: Audi A4 on Business plan 2318 (12 Month). 10000 Miles. ¶œ60.00 Insurance I used the following expression:- Car plan: Mid([offer],InStr(1,[offer]," on...

Hi I am trying to learn VBA where is the best place to start. Please let me know about any good resources such as book and wedsites. :cool:

Can someone please tell me how I can split the following data in to separate fields? LG 8180 on Three Video, Talk&Text 1300 (12 Month). 1000 Mins 150 Texts. ¶œ60.00 Line Rental Sony Ericsson K608i on Three Video, Talk&Text 2600 (12 Month). 2000 Mins 300 Texts. ¶œ100.00 Line Rental LG 880 +...