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

Sorry I did not get you....

"renegan" wrote:


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