Change the case of text - Microsoft Support
WEBFirst, insert a temporary column next to the column that contains the text you want to convert. In this case, we’ve added a new column (B) to the right of the Customer Name column. In cell B2, type =PROPER (A2), then press Enter. This formula converts the name in cell A2 from uppercase to proper case.
Create a list of sequential dates - Microsoft Support
WEBExcel Help & Training. Rows & columns. Create a list of sequential dates. You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command. Use the Fill Handle. Select the cell that contains the first date. Drag the fill handle across the adjacent cells that you want to fill with sequential dates.
Customize page numbers and their formats in different Word …
WEBTo choose a format or to control the starting number, select Page Number > Format Page Numbers. Do either or both of the following: Select Number format to select the format for the numbering, such as a, b, c or i, ii, iii for the intro. Under Page numbering, choose Start at and type a number that you want to start the section with.
Change or delete a header or footer on a single page
WEBChange or delete a header or footer on a single page - Microsoft Support. Word for Microsoft 365 Word for Microsoft 365 for Mac Word for the web More... Windows macOS. Change or delete the header or footer from the first page. Double-click the first page header or footer area. Check Different First Page to see if it's selected. If not:
Indent the second line in Word - Microsoft Support
WEBGo to Home > Paragraph dialog launcher > Indents and Spacing. Under Special, select one of the following indent styles: Hanging. First Line. None. On Hanging and First Line indents, you can adjust the depth of the indent with the By field. Select OK.
Cancel all future meetings in a series - Microsoft Support
WEBThe best way to cancel remaining meetings in a series is to send a meeting update with a new end date. Note: Once you click OK, the meeting agenda, notes, and attachments that were added to the previous instances of the series will be deleted. On the navigation bar, click Calendar. Double-click any meeting in the series.
SUBSTITUTE function - Microsoft Support
WEBDescription. Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string. Syntax. SUBSTITUTE (text, old_text, new_text, [instance_num])
Learn to build an expression - Microsoft Support
WEBLearn to build an expression. Access for Microsoft 365 Access 2021 Access 2019 Access 2016. You can use expressions to do all kinds of things with your data. For example, determine how many days have passed since an order was shipped, or combine a FirstName and a LastName into a FullName.
String functions and how to use them - Microsoft Support
WEBChange the case of a string to upper or lower case. UCase function or LCase function. =UCase ( [FirstName]) If [FirstName] is “Colin”, the result is “COLIN”. Determine the length of a string. Len function. =Len ( [FirstName]) If [FirstName] is “Colin”, the result is 5. * Okay, so it’s not a function, it’s an operator.
Create a hanging indent - Microsoft Support
WEBWindows macOS Web. Select the text where you want to add a hanging indent. Go to Home > Paragraph dialog launcher > Indents and Spacing. Under Special, select Hanging. You can adjust the depth of the indent using the By field. Select OK. To add a drop cap to your paragraph, see Insert a drop cap.
Using Flash Fill in Excel - Microsoft Support
WEBTo turn Flash Fill on, go to Tools > Options > Advanced > Editing Options > check the Automatically Flash Fill box. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. See Also. Training video: AutoFill and FlashFill. Combine text from two or more cells into one cell.
Skip to content