Results 1 to 21 of 21

Find and Replace

Threaded View

pbf98 Find and Replace 02-25-2013, 01:08 PM
Pepe Le Mokko Re: Find and Replace, is... 02-25-2013, 01:25 PM
crabiajohan Re: Find and Replace, is... 02-26-2013, 07:55 AM
pbf98 Re: Find and Replace, is... 02-25-2013, 01:39 PM
Pepe Le Mokko Re: Find and Replace, is... 02-25-2013, 01:41 PM
K m Re: Find and Replace, is... 02-25-2013, 01:42 PM
pbf98 Re: Find and Replace, is... 02-25-2013, 01:49 PM
K m Re: Find and Replace, is... 02-25-2013, 01:49 PM
Pepe Le Mokko Re: Find and Replace, is... 02-25-2013, 01:54 PM
pbf98 Re: Find and Replace 02-25-2013, 02:09 PM
K m Re: Find and Replace 02-25-2013, 02:14 PM
Pepe Le Mokko Re: Find and Replace 02-25-2013, 03:33 PM
pbf98 Re: Find and Replace 02-25-2013, 03:40 PM
K m Re: Find and Replace 02-25-2013, 03:54 PM
K m Re: Find and Replace 02-25-2013, 03:56 PM
pbf98 Re: Find and Replace 02-25-2013, 04:16 PM
NeedForExcel Re: Find and Replace 03-16-2013, 04:40 AM
pbf98 Re: Find and Replace 02-25-2013, 04:51 PM
pbf98 Re: Find and Replace 02-25-2013, 05:01 PM
Pepe Le Mokko Re: Find and Replace 02-26-2013, 07:46 AM
NeedForExcel Re: Find and Replace 03-18-2013, 05:37 AM
  1. #1
    Registered User
    Join Date
    02-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    8

    Find and Replace

    I have a spread sheet with over 3360 rows and in column a I have a number that goes up by 1 every 7 rows.
    So The column looks like:

    1
    1
    1
    1
    1
    1
    1
    2
    2
    2
    2
    2
    2
    2
    3...


    I have to change all those numbers to match a new set of numbers. So for an actual example from my spread sheet 145802 has been changed to 146522, 145803 changed to 146523, and so on, each one just add 1 more
    Currently the way I am doing it is using find and replace. This way I have to do a find a replace 480 times but if there is another more efficient way I would appreciate the advice a lot! As it will save me a lot of time down the line because I will be doing this same process 4 more times

    Thanks for any help you can offer, and if something needs better explaining, I will do my best to explain a little bit better.
    Thank you!
    Last edited by pbf98; 02-25-2013 at 05:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1