RE: Finding text in Excel 2003

Bill
Sounds like a convoluted exercise.  Using Word sounds a good idea
because if you were in the same spreadsheet as your source data, you
would be foreever switching focus from the source to the target cell,
whereas with two apps, you can just alt tab between them.

Cheers
Chris    

-----Original Message-----
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
Behalf Of Bill Tipton
Sent: 28 March 2008 04:11
To: jfw@xxxxxxxxxxxxx
Subject: RE: Finding text in Excel 2003

Hi all,

Since we are talking about searching in Excel 2003.
Does anyone know how to do multiple searches within a cell?
I have some cells in a spreadsheet with up to 4 pages of unformatted
text in a column of cells I need to search through data and put
into other cells in same spreadsheet. 

I will have reoccurrences of same search string within the cell I am
searching. 

So far I have not even figured out a way to read word by word or
sentence by sentence within a cell to copy what I want. So I copy
the complete cell to Word and do my searching  in Word

I am using latest version of Jaws 9.

Thanks,

Bill


 

-----Original Message-----
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
Behalf Of Tom Lange
Sent: Wednesday, March 26, 2008 6:22 PM
To: jfw@xxxxxxxxxxxxx
Subject: Re: Finding text in Excel 2003

Hi,
That's a whole lot better than my suggestion to use ctrl+y, since it 
announces the cell in which it's found.  Cool. I thought maybe this is 
specific to JAWS but it's not.  It works with Window-Eyes, too.

Thanks a bunch.
Tom

----- Original Message ----- 
From: "Steve & Shannon" <cookcafe@xxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Wednesday, March 26, 2008 3:57 PM
Subject: RE: Finding text in Excel 2003


> Try shift F4.  I just tried it before writing this message and it
worked.
> This also works in word.
>
>
> Steve & Shannon
> Today I married my best friend.
> The one that I laugh with, live for, love.
> October 11, 2003
> -----Original Message-----
> From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
Behalf
> Of Richard sherman
> Sent: Wednesday, March 26, 2008 2:09 PM
> To: jfw@xxxxxxxxxxxxx
> Subject: Finding text in Excel 2003
>
> Hi,
>
> Using excel 2003, does anyone know the keystroke to repeat a text find

> there
>
> without opening the find dialog box repeatedly?
>
> You cannot use control + page up or down like you can in word, this
cycles
> between sheets in the workbook. Also tried to use the f3 key, but to
no
> avail.
>
> Thanks for the advice in advance.
>
> Rich
>
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list:
> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to
> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject
line.
> Archives located at: http://www.freelists.org/archives/jfw
>
> If you have any concerns about the list, post received from the list,
or 
> the
> way the list is being run, do not post them to the list. Rather
contact 
> the
> list owner at jfw-admins@xxxxxxxxxxxxxx
>
> --
> JFW related links:
> JFW homepage: http://www.freedomscientific.com/
> Scripting mailing list: 
> http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
> JFW List instructions:
> To post a message to the list, send it to jfw@xxxxxxxxxxxxx
> To unsubscribe from this mailing list, send a message to 
> jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject
line.
> Archives located at: http://www.freelists.org/archives/jfw
>
> If you have any concerns about the list, post received from the list,
or 
> the way the list is being run, do not post them to the list. Rather 
> contact the list owner at jfw-admins@xxxxxxxxxxxxxx 

--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: http://www.freelists.org/archives/jfw

If you have any concerns about the list, post received from the list, or
the way the list is being run, do not post them to the
list. Rather contact the list owner at jfw-admins@xxxxxxxxxxxxxx

--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: http://www.freelists.org/archives/jfw

If you have any concerns about the list, post received from the list, or
the way the list is being run, do not post them to the list. Rather
contact the list owner at jfw-admins@xxxxxxxxxxxxxx

This e-mail has come from Experian, the only business to have been twice named 
the UK's 'Business of the Year’ 
Have you read our new resource on Affinity Marketing 'Everybody is Somebody's 
Customer' where we share our experience of managing successful affinity 
campaigns? Download from www.experianim.com/affinitymarketing
(simply paste the URL into your web browser)
===================================================================================
Information in this e-mail and any attachments is confidential, and may not be 
copied or used by anyone other than the addressee, nor disclosed to any third 
party without our permission. There is no intention to create any legally 
binding contract or other binding commitment through the use of this electronic 
communication unless it is issued in accordance with the Experian Limited 
standard terms and conditions of purchase or other express written agreement 
between Experian Limited and the recipient. 
Although Experian has taken reasonable steps to ensure that this communication 
and any attachments are free from computer virus, you are advised to take your 
own steps to ensure that they are actually virus free. 
Companies Act information:
Registered name: Experian Limited 
Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH 
Place of registration: England and Wales 
Registered number: 653331

--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list: 
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to 
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: http://www.freelists.org/archives/jfw

If you have any concerns about the list, post received from the list, or the 
way the list is being run, do not post them to the list. Rather contact the 
list owner at jfw-admins@xxxxxxxxxxxxxx

Other related posts: