Trim Function
On 31/07/2007 23:38:06, "Fred Smith" wrote:
Yes, there's a way around it. However, it depends on the solution you
need. What do you want the results to be?
I just want the name left intact. If the name consists of multiple words, I
would like those left intact.
Ater the names could be the following:-
Any number from 1 to 1000.
Any number from 1 to 1000 + (13F). (The number in brackets could be 1 to 1000
and include J instead of F. Any of the above could be preceded by:-
(ex3)
(ex4)
(ex5)
(ex6)
(ex7)
Thanks for the feedback everybody.
I'll give the the other suggestions a whirl later on.
|