Thread: How can I replace data in excel ?...Data positionsis a bit complic
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
renegan
 
Posts: n/a
Default How can I replace data in excel ?...Data positionsis a bit complic

Lets say your data is in cell A1:

=REPLACE(REPLACE(A1,1,3,),6,4,)


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=535110

Reply With QuoteReply With Quote