ENG-WORCESTER-L Archives

Archiver > 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
References: <NEBBLHPOILEBAGELAHLFKEEODBAA.janet@food-machineryco.com><dIET5AA2SHR8EwzH@malfinch.demon.co.uk>
In-Reply-To: <dIET5AA2SHR8EwzH@malfinch.demon.co.uk>



to convert words

1 copy and save in Word
2 use 'change case' under Format
3 copy and transfer back to Excel

Bryan Slim
Canada



>
> >Also how can we convert a column of names......
>>Troude
>>Poole
>>Bond
>>Cade
>>Bayly
>>to be all in uppercase .........
>>TROUDE
>>POOLE
>>BOND
>>CADE
> >BAYLY
>>
>>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!!
>>
>>Thanks Janet
>>
>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
>back in.
>
>Hope that this helps.
>If you find a date fix for Excel please let me know.
>
>Best wishes,
>--
>Bill Finch Malvern England
>
>e_mail:
>
>
>==== ENG-WORCESTER Mailing List ====
>Transcribers wanted for Worcestershire FreeREG
>for more information see http://freereg.rootsweb.com
>UK Census on-line
>http://freecen.rootsweb.com/
>http://www.worcestershiresurnames.co.uk/

This thread: