I have a problem to extract a few word from a sentence. For example i just want 35 from the sentence " 35 PLTS Electrical Material ". Can it be done ? Thank !
Subject: Extract a Word
There are a few Formula and function can be used. Such as:@Left, @LeftBack, @right,@rightBack, @middle, @MiddleBack
Left, Right, Middle
Subject: Extract a Word
If you know the position of the word, you can use the aptly named @Word function.
Subject: Extract a Word
I have a script library with that routine in it. If you would like it, post an address an I e-mail an attachment to. --Ron
Subject: teoct@pcs.po.my
Subject: RE: teoct@pcs.po.my
My e-mail to “teoct@pcs.po.my” was returned.