| View previous topic :: View next topic |
| Author |
Message |
MyCousinBob Newbie

Joined: 20 Feb 2012 Posts: 2
|
Posted: Mon Feb 20, 2012 10:50 pm Post subject: [SOLVED]Find and Replace a range of numbers |
|
|
So I'm having a little problem. I need to be able to replace a range of numbers in a sheet with the same thing. Like for example, I have a list of 100 random numbers. I want to replace numbers 1-10 with A, numbers 11-25 with B, numbers 26-50 with C. Is this there any way to do this that's faster than just manually changing each one?
Last edited by MyCousinBob on Tue Feb 21, 2012 12:11 am; edited 1 time in total |
|
| Back to top |
|
 |
karolus OOo Advocate

Joined: 22 Jun 2011 Posts: 208
|
Posted: Mon Feb 20, 2012 11:38 pm Post subject: |
|
|
Hallo
→Edit→Search and replace:
all with Option [x]regular Expression
1.search [1-9]|10 replace with A
2.search (1[1-9])|(2[0-5]) replace with B
3.search (2[6-9])|([34][0-9])|50 replace with C
Karo |
|
| Back to top |
|
 |
MyCousinBob Newbie

Joined: 20 Feb 2012 Posts: 2
|
Posted: Tue Feb 21, 2012 12:11 am Post subject: |
|
|
| Thanks man, you just saved me 20+ hours of work. |
|
| Back to top |
|
 |
|