Thread: Trim Function
View Single Post
  #3   Report Post  
Steved
 
Posts: n/a
Default

Thanks Biff

"Biff" wrote:

=LEFT(A1,3)*1

Biff

"Steved" wrote in message
...
Hello from Steved

I have 4 numerals say 1234 what trim function would I use please to return
a 3 numeral value ie 123

Thankyou.