Roz | search
Click here to view Roz news from 60+ newspapers.
Bookmark or Share- Split text into different columns with functions - Microsoft SupportSplit text into different columns with the Convert Text to Columns Wizard. You can use the LEFT, MID, RIGHT, SEARCH, and LEN text functions to manipulate strings of text in your data.
- Freeze panes to lock rows and columns - Microsoft SupportHow to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
- NOMINAL function - Microsoft SupportThe NOMINAL function syntax has the following arguments: Effect_rate Required. The effective interest rate. Npery Required. The number of compounding periods per year. Remarks. Npery is truncated to an integer. If either argument is nonnumeric, NOMINAL returns the #VALUE! error value.
More
