View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Murph Murph is offline
external usenet poster
 
Posts: 37
Default remove and replace a digit...

I am trying to remove a digit and replace it with another digit.

I.E.: A1 has '2001' in the cell... I want to change that to '9001'.

I have dabbled with =left (a1,3) to remove the '2' but cannot figure out how
to place the 9 in.

Thanks in advance.