I don't use excel much so there might be a better way of doing this.
Assuming the uppercase name is in A1, the following should work:
=UPPER(LEFT(A1,1)) & LOWER(MID(A1,2,LEN(A1)-1))
Donna
If the paragraphs that are changing all carry the same paragraph style, then maybe Automatically Update (for the Style) has been checked.
The following are for Word97 - Word2000 may be different
1. click in a paragraph that has gone awry
2. from the format menu choose style
3. click on the...
When you first add the menu, is there a 'Save in' option that let's you choose where the customisation should be saved?
For example, in Word97 I would choose Tools - Customise - Commands tab and at the bottom of the dialog box is a SAVE IN dropdown list that let's me choose either Normal or the...
I'm assuming that you want to look in New.dot to get an AT entry to insert into your document???
Replace 'enter path here' and 'Autotext name' with appropriate information.
Sub test()
Dim myTP As String
myTP = "c:\ enter path here \New.dot"...
It's a border.
Select the paragraphs around the line.
Choose Borders and shading from the Format menu.
Click on the None icon (top left hand corner).
Click on OK.
If the line keeps moving to other paragraphs then do the same for that paragraph (or even select the entire document and do it)...
The following instructions are for NT4 and Office97
Right click on the Office Bar and choose Customize.
Click on the buttons tab.
Remove the buttons that do not work.
Choose Add File and navigate to the .exe file for the application to add a button.
Note - If you are going to rename the...
Go to the Word startup directory (possibly c:\Program Files\Microsoft Office\Office\Startup). The template(s) you are after are probably here.
Drag the template out of this folder. If you then open the template (not by double clicking on it - do a right-click, open or File-Open) you should be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.