LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to replace numbers in sequence without sorting? geniusideas Excel Programming 1 July 20th 10 11:48 PM
Can excel find a sequence of numbers from a known total? efandango Excel Worksheet Functions 16 February 15th 07 11:40 PM
How to find & replace a formula sequence with * in it? creativeops Excel Discussion (Misc queries) 2 September 8th 06 05:17 PM
find missing numbers in a sequence kaytoo Excel Discussion (Misc queries) 1 June 13th 06 05:09 PM
find missing numbers in a sequence kaytoo Excel Discussion (Misc queries) 1 June 13th 06 04:43 PM


All times are GMT +1. The time now is 05:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"