Thread: Help removing "space" character (question updated)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Help removing "space" character (question updated)
2. presuming yr data starts in A1 (in some other column) use the
formula:
=LEFT(A1,LEN(A1)-1)
to get rid of spaces in the end, then copy and paste special as values

HIH
Reply With QuoteReply With Quote