Thread: how can i change a sequence of numbers using find replace
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default how can i change a sequence of numbers using find replace
Hi,

Am Mon, 24 Mar 2014 14:37:07 +0000 schrieb sumesh56:

numbers from 301 to 309. i want to change

these to 311 to 319.

write in a empty cell 10 = copy this cell = select your range of
numbers = Paste = Paste Special = Add


Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Prodessional
Reply With QuoteReply With Quote