Removing selected text from a string

[alastair69]

Dear All,

Thank you for taking the time to look at this Question.

I am using a form in which i only need the last sections.

example:-
G/001 - Ceiling - Tiles - Perforated. this is what i get at the second, but i would like to drop the "G/001 - " and just have "Ceiling - Tiles - Perforated.", has anybody got any ideas on how to do this please.

 

[ghudson]

You need to parse your data. Look up the Mid() and Instr() functions. Plenty of threads floating around here on that subject.