Thread: Remove last character from all data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JR JR is offline
external usenet poster
  
Posts: 8
Default Remove last character from all data
Figured it out:

Sub fixme()
Selection.Replace What:=Chr(160), Replacement:="", LookAt:=xlPart,
_
SearchOrder:=xlByRows, MatchCase:=False
End Sub


Reply With QuoteReply With Quote