Can I do this in EXCEL? - removing text from multiple rows so only specified codes remain

  • Thread starter Thread starter bob green
  • Start date Start date
B

bob green

I have data in the following format in a spreadsheet :

$GROUP social puts in $FEEL-GOOD better mood $DISTRESS gets in good
mood

$AVAILABLE day off $RELAX relaxing and $PHYSICAL FUNCTION sleep better
and $HABIT part of regular routine.


I want to be able to remove the text so only the codes remain, e.g.,

$GROUP $FEEL-GOOD $DISTRESS
$AVAILABLE $RELAX $PHYSICAL FUNCTION $HABIT



Can I do this using EXCEL?

Any assistance is appreciated,

regards

Bob Green
 
You would be better off doing this in MS Word and since the majority of
Excel users
has Office maybe you have that too? Copy over the data to word as text, do
edit>replace, in the find what put

<[a-z]{2,20}>

select use wildcards and leave the what box empty

if there are words with more that 20 letters change the 20 within the
parenthesis to
cover that
 
Sorry, should have been "leave the replace with box empty"

--

Regards,

Peo Sjoblom

Peo Sjoblom said:
You would be better off doing this in MS Word and since the majority of
Excel users
has Office maybe you have that too? Copy over the data to word as text, do
edit>replace, in the find what put

<[a-z]{2,20}>

select use wildcards and leave the what box empty

if there are words with more that 20 letters change the 20 within the
parenthesis to
cover that

--

Regards,

Peo Sjoblom

bob green said:
I have data in the following format in a spreadsheet :

$GROUP social puts in $FEEL-GOOD better mood $DISTRESS gets in good
mood

$AVAILABLE day off $RELAX relaxing and $PHYSICAL FUNCTION sleep better
and $HABIT part of regular routine.


I want to be able to remove the text so only the codes remain, e.g.,

$GROUP $FEEL-GOOD $DISTRESS
$AVAILABLE $RELAX $PHYSICAL FUNCTION $HABIT



Can I do this using EXCEL?

Any assistance is appreciated,

regards

Bob Green
Click to expand...
Click to expand...
 
Back
Top