Thread: removing last 16 digits of the value of a cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
MDubbelboer MDubbelboer is offline
external usenet poster
  
Posts: 1
Default removing last 16 digits of the value of a cell

SimonCC Wrote:
Try:
=LEFT(A1,LEN(A1)-16)


well take 17 to get rid of the space
=left(a1,len(a1)-17)
or
=trim(left(a1,len(a1)-16)


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=562652

Reply With QuoteReply With Quote