Thread: Trim Function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Saxman[_2_] Saxman[_2_] is offline
external usenet poster
 
Posts: 33
Default 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.