Thread: Formula Needed - Truncate extra spaces at end of variable text len
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
  
Posts: 1,358
Default Formula Needed - Truncate extra spaces at end of variable text len
=TRIM(A1)
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Roibn Taylor" wrote:

Apollo Environmental Strategies
B&B Laboratories

The cells pasted above have variable blank spaces at the end. I need
spaces removed at the end of each cell using a formula.
--
Thanks for the help in advance
Reply With QuoteReply With Quote