ENG-WORCESTER-L ArchivesArchiver > ENG-WORCESTER > 2002-01 > 1011133002
From: Bryan SLIM <>
Subject: Re: [WOR] Excel Specialist help urgently required
Date: Tue, 15 Jan 2002 14:16:42 -0800
to convert words
1 copy and save in Word
2 use 'change case' under Format
3 copy and transfer back to Excel
> >Also how can we convert a column of names......
>>to be all in uppercase .........
>>Sorry to be off list with this but I hope that you will make an exception as
>>this stuff is gold dust and it'll get out there more quickly if we convert
>>the files less manually. At the moment each one is being changed
>>individually and it is a real slog!
>>Your help would be appreciated and if I get a solution I will let you know
>>asap to save anyone any additional work!!
>We had this problem with early dates and date sorts when listing MIs of
>a Church in Worcestershire.
>We haven't fixed it yet but intend to try soon. A friend advised us to
>look at the Excel Web site for a macro. As you probably know dates in
>Excel do not work earlier than Jan 01 1900.
>I do not know how to change the case of fields. A trick I used at work
>was to save the data as comma separated data to a file. I then edited
>the file using a text editor and then used Excel to read the edited file
>Hope that this helps.
>If you find a date fix for Excel please let me know.
>Bill Finch Malvern England
>==== ENG-WORCESTER Mailing List ====
>Transcribers wanted for Worcestershire FreeREG
>for more information see http://freereg.rootsweb.com
>UK Census on-line
|Re: [WOR] Excel Specialist help urgently required by Bryan SLIM <>|