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

Joined: 13 Jun 2012 Posts: 2
|
Posted: Wed Jun 13, 2012 11:34 am Post subject: How to delete first word in a series of cells |
|
|
Hi, I'd like to know how to delete the first word in a series of cells.
For example, I have a vertical vocabulary list, with thousands of words and definitions; I'm trying to remove the word and only keep the definition.
E.g: I want:
vociferous adj. Making a loud outcry.
vogue n. The prevalent way or fashion.
volant adj. Flying or able to fly.
to become:
adj. Making a loud outcry.
n. The prevalent way or fashion.
adj. Flying or able to fly.
Cheers |
|
| Back to top |
|
 |
karolus OOo Advocate

Joined: 22 Jun 2011 Posts: 208
|
Posted: Wed Jun 13, 2012 12:06 pm Post subject: |
|
|
Hallo
Select the Column and goto →Tools→Search and replace:
Search for:
^[^ ]+ (.*)$
replace with:
$1
with Options:
[x] Selection only
[x] regular Expression
→replace all
Karo |
|
| Back to top |
|
 |
Jiv Newbie

Joined: 13 Jun 2012 Posts: 2
|
Posted: Wed Jun 13, 2012 1:12 pm Post subject: |
|
|
Cool, thank you very much! (btw, it was in Edit->Find & Replace) |
|
| Back to top |
|
 |
AMTEK Newbie

Joined: 19 Sep 2012 Posts: 4
|
Posted: Thu Sep 20, 2012 8:01 am Post subject: |
|
|
| karolus wrote: | Hallo
Select the Column and goto →Tools→Search and replace:
Search for:
^[^ ]+ (.*)$
replace with:
$1
with Options:
[x] Selection only
[x] regular Expression
→replace all
Karo |
Hi. Trying to remove the 1st word out of a particular column as well. When I search ^[^ ]+ (.*)$ nothing is returned.... what am I doing wrong?
I am trying to get this:
Fax: (XXX) XXX-XXXX
to be this
(XXX) XXX-XXXX
for an entire column.
Thank you. |
|
| Back to top |
|
 |
JohnV Administrator

Joined: 07 Mar 2003 Posts: 8995 Location: Lexinton, Kentucky, USA
|
Posted: Thu Sep 20, 2012 11:28 am Post subject: |
|
|
| Quote: | | what am I doing wrong? | You need to check Regular Expressions under More Options. |
|
| Back to top |
|
 |
AMTEK Newbie

Joined: 19 Sep 2012 Posts: 4
|
Posted: Thu Sep 20, 2012 12:45 pm Post subject: |
|
|
| Thank you! |
|
| Back to top |
|
 |
|