Thread: Trim Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
somethinglikeant somethinglikeant is offline
external usenet poster
  
Posts: 94
Default Trim Help
You could use the mid function to pare off 3 digits of the string at a
time. Say your string was in cell A1:-
=Mid(A1,1,3), = Mid(A1,4,3), etc

somethinglikeant

Reply With QuoteReply With Quote