Bookmark This Site Keep up with our Tips

Tip of the Day RSS Feed Fresh Software Tips Daily

Sponsor Program
Our tips are powerful. Our writers are experts. Our results are guaranteed.

Listen to our Radio Show
Hot topics for both consumers and webmarketers on WebmasterRadio.FM Every Wednesday, 4PM Eastern.

	Convert minutes into hours, minutes and seconds in Excel To convert a number of minutes into a more conventional hours, minutes and seconds format in Excel, just follow these two simple steps: 1) Divide the number by (24*60), so if the number is in cell A1, put a formula in any other cell which reads =A1/(24*60) 2) Then choose the required time format from Format, Cells, Number.
	Save Tip Comments Tip Rating

	Adding gridlines to your Excel chart Gridlines can make it easier for people to estimate the values represented in your chart. To add them in, select the chart and select Chart Options from the Chart menu. Select the Gridlines tab at the top. From this screen you can add both minor and major gridlines to the X and/or Y axis.
	Save Tip Comments Tip Rating

	Help with formulas in Excel If you know the Excel function that you need and remember some of the details, you can get a very helpful reminder by typing =function (where function is the name of the function that you want to use, e.g. Sum or If or whatever), holding down Ctrl and Shift and pressing A. The arguments for the function are inserted into the cell and you can type over them (remember that you can double click on each part to select it and then just type to replace it).
	Save Tip Comments Tip Rating

	Quickly format a table in Excel To quickly format a table in Excel, select the table and choose AutoFormat from the Format menu. Select a format from the right hand side (the preview window will show you what it will look like) and press OK.
	Save Tip Comments Tip Rating

	Uses for the F11 key in Excel In Excel, the F11 key creates a chart from the selected data. Shift - F11 inserts a new worksheet. Ctrl - F11 inserts a Microsft Excel 4.0 macro sheet. Alt - F11 displays the Visual Basic Editor.
	Save Tip Comments Tip Rating

	Display Range names directly in the Excel worksheet To display Range names directly in a worksheet, zoom out to 39 percent or less. Excel puts a border around each range and shows the name of that range in blue (this feature is for display purposes only and will not print).
	Save Tip Comments Tip Rating

	Goto commands in Excel Excel has a really useful Goto command. Just press F5 and enter a cell reference (or range name) and press OK. Selecting the Special option allows you to choose a wide variety of Goto options.
	Save Tip Comments Tip Rating

	Incorporate your Excel chart into a standard worksheet If your Excel chart is on a sheet of its own, it´s easy to move it back to be part of another worksheet. Select the chart and select Location from the Chart menu and choose As Object In and select the worksheet you want to put the chart into. Click OK.
	Save Tip Comments Tip Rating

	Avoid pies with everything in Excel The most common cause of problems when producing charts is caused by people attempting to create pie charts from multiple data series. A pie chart will allow to show one series of data broken down into its separate sections, but can not show more than one data series. Consider using a doughnut chart instead.
	Save Tip Comments Tip Rating

	Move quickly to a specific Excel worksheet Want a quick way to quickly move to a particular Excel worksheet, even if the sheet names won´t all fit along the bottom of the sheet? Right click on the sheet navigation buttons (to the left of the sheet tabs) and select the desired worksheet from the list that appears.
	Save Tip Comments Tip Rating

	Uses for the F1 key in Excel In Excel, F1 will activate Microsoft´s Help tool. Alt - F1 will create a default chart from the selected data. Shift - F1 will activate the ´What´s This´ section of Microsoft Help. Click on any part of the screen to see what it is. Alt - Shift - F1 will insert a new worksheet.
	Save Tip Comments Tip Rating

	Converting hours and minutes into minutes in Excel There is a way to convert time expressed in hours and minutes into minutes only, even though Excel doesn´t have a minutes-only format. Enter a measure of time in hours and minutes, such as 2:25, into any cell, such as A1. In another cell, enter the formula =Hour(A1)*60+minute(A1). Excel will then convert the time into minutes. If the result is still in time format (00:00 or similar), then click the Comma Style button (to the right of the percentage button) on the toolbar or select the General format from Format, Cells, Number.
	Save Tip Comments Tip Rating

	Insert a hyperlink in Excel To insert a hyperlink into an Excel cell, click in the cell, hold down Control and press K. The hyperlink dialog box appears and you can choose to link to an external file, a worksheet in the open workbook or even a named range in the current workbook.
	Save Tip Comments Tip Rating

	Automatically extend a series in Excel When working with any logical series (Days of the week, months of the year, Q1, Q2 etc), let Excel do the hard work for you. Enter the first entry and click and drag the fill handle (found at the bottom right hand corner of the cell). Excel will complete the series for you.
	Save Tip Comments Tip Rating

	Save time when formatting in Excel To save continually recreating the same formats each time you create a spreadhseet, use Excel´s built in Style function. Apply the formatting you require to a cell or group of cells, then select those cells. Click in the Style Box on the toolbar next to the font selector (which will generally say normal), type a name for your style and press enter. The style can now be applied just by selecting the cells where you want to apply it and selecting your style name from the drop down list. Note: Style names can´t contain spaces or hyphens - use underscores or capital letters instead.
	Save Tip Comments Tip Rating

	Go to the last cell in your table in Excel To move to the last cell in your table in Excel, hold down the control key and press end (This is a little unreliable, but give it a go).
	Save Tip Comments Tip Rating

	Drag and drop to move cells in Excel While cut and paste can be used in Excel to move cells from one place to another, major time savings can be had from using drag and drop. Select the cells you want to move and release the mouse button. Move the cursor to any edge of the selected cells (the cursor will change to a white arrow), click and hold the mouse button down and move to the required place. Release the mouse button and the cells will be moved to the new position.
	Save Tip Comments Tip Rating

	Change the data an Excel chart is based on If you´ve spent time creating an Excel chart, it can be really frustrating to have to recreate the chart every time you want to add a column or row. To change the selection that a chart is based on, select the chart and select Data Source from the Chart menu. From the Data Source dialog box, simply drag over the complete selection that you want to include in your chart and press OK.
	Save Tip Comments Tip Rating

	Converting hours and minutes into minutes in Excel There is a way to convert time expressed in hours and minutes into minutes only, even though Excel doesn´t have a minutes-only format. Enter a measure of time in hours and minutes, such as 2:25, into any cell, such as A1. In another cell, enter the formula =Hour(A1)*60+minute(A1). Excel will then convert the time into minutes.
	Save Tip Comments Tip Rating

	Select the data in a column with the mouse in Excel To select the data in an Excel column using the mouse, hold down the shift key and double click on the bottom edge of the top cell.
	Save Tip Comments Tip Rating

	Rename your chart tab in Excel If you create an Excel chart as a new sheet, then the sheet will have been named something like Chart 1 (or 2 or whatever). To rename the sheet, simply double click on the tab containing the name (at the bottom of the workbook) to highlight it and type the name you require.
	Save Tip Comments Tip Rating

	Formatting your Excel chart Once you´ve created your Excel chart, you can format almost every part of it simply and quickly. Either double clicking or right clicking (and selecting Format) on the element you wish to format will bring up a dialog box which allows you to do just that.
	Save Tip Comments Tip Rating

	Activate AutoSum from the keyboard in Excel When using autosum in Excel, it can be frustrating to keep switching between keyboard and mouse all the time. To activate the AutoSum function with the keyboard, select the cell where you want the answer to be, hold down the Alt key and press =.
	Save Tip Comments Tip Rating

	Insert a new Excel worksheet When you need to insert a new Excel worksheet, most people are aware that they can select Worksheet from the Insert menu. There are also keyboard shortcuts which will do the same thing quicker. Two shortcuts to insert a new worksheet are: Hold down Shift and press F11 Hold down Alt and Shift and press F1
	Save Tip Comments Tip Rating

	Re-order the worksheets in an Excel workbook If you find that the worksheets in an Excel workbook are not in the most convenient order (particularly if there are a large number of worksheets), don´t worry - you can reorder them very easily. If you click and drag the worksheet name to the left or right, you can reposition the worksheets exactly where you want them.
	Save Tip Comments Tip Rating

	Uses for the F3 key in Excel In Excel, the F3 key activates the Paste Name dialog box. Shift - F3 activates the Paste Function dialog box. Ctrl - F3 activates the Define Name dialog box. Ctrl - Shift - F3 activates the Create Name dialog box.
	Save Tip Comments Tip Rating

	Enter more than one line of text in an Excel cell If you want to spread the contents of an Excel cell over more than one line, type as normal, but when you reach the end of a line, hold down Alt and press Enter. A new line will start within the same cell.
	Save Tip Comments Tip Rating

	Positioning the chart legend in Excel Most default Excel chart types include a legend and most position that legend at the right hand side of the chart. If that suits you, then fine but if you want to either remove it or reposition it, then you can do so easily. Select the chart and select Chart Options from the Chart menu. Click the Legend tab at the top. From this screen you can remove the legend by clearing the Show Legend check box or reposition the legend by choosing any of the Placement options.
	Save Tip Comments Tip Rating

	Excel´s SUBSTITUTE function - What does it do? Excel´s SUBSTITUTE function substitutes new text for old text within a text string. If cell A1 contains Michael Gurner, cell B1 contains Michael and cell C1 contains Mike, then: =SUBSTITUTE(A1,B1,C1) would return Mike Gurner.
	Save Tip Comments Tip Rating

	Excel´s LOWER function - What does it do? Excel´s LOWER function will convert all text (whatever the case) to lowercase text. If cell A1 contains MiCHaeL, then: =LOWER(A1) returns michael
	Save Tip Comments Tip Rating

	Insert todays date quickly in Excel To insert todays date into an Excel cell, hold down the control key and press ; (semi-colon).
	Save Tip Comments Tip Rating

	Apply a standard time format in Excel To apply a standard time format in Excel, hold down the Ctrl and Shift keys and press @.
	Save Tip Comments Tip Rating

	Moving to the end of a row in Excel Need to move to the end of a row of data in Excel using the keyboard? Hold down the control key and press the right (or left arrow).
	Save Tip Comments Tip Rating

	Excel´s FIXED function - What does it do? Excel´s FIXED function formats a number as text with a number of decimals which you specify, with or without commas. If cell A1 contains 123456 (formatted as a number), then: =FIXED(A1,3,TRUE) returns 123456.000
	Save Tip Comments Tip Rating

	Quickly apply currency formatting in Excel To quickly apply currency formatting in Excel, select the cells you wish to format, hold down the Ctrl and Shift keys and press the $ key.
	Save Tip Comments Tip Rating

	View more than one Excel worksheet at once Constantly switching between Excel worksheets can be frustrating and can really damage your productivity. To show more than one worksheet on screen at the same time, follow these simple steps: 1) From the Window menu, select New Window (do this for each additional worksheet which you want to view) 2) Select Arrange from the Window menu 3) Put a tick in the ´Windows of Active Workbook´ box 4) Choose the way you want your window arranged (tiled, vertical etc) and press OK Each window will now be displayed separately and you can show a different worksheet in each one.
	Save Tip Comments Tip Rating

	Let Excel know you´re entering a formula Excel needs some help in differentiating between text, numbers and formulas. To let Excel know that you´re entering a formula, always start the formula with an = sign.
	Save Tip Comments Tip Rating

	Show exactly what each chart section represents in Excel Excel charts can be great at giving people a general picture of what data represents, but they can also be used to show very specific information. A value can be shown on each row/column so that the reader can see exactly what the chart is showing. To activate this, select your chart and select Chart Options from the Chart menu. Click on the Data Labels at the top and choose the Show Value option.
	Save Tip Comments Tip Rating

	Setting the default Excel chart If you find yourself regularly creating the same kind of Excel chart, you might want to consider setting that chart type as your default. Creat the chart and then select Chart Type from the Chart menu. Click on the Set As Default button. That chart type will now appear as the default when you use the chart wizard or when you press F11.
	Save Tip Comments Tip Rating

	Creating an Excel chart in a single click What´s the quickest way to create an Excel chart? Select the data that you want to chart and press F11. That´s it.
	Save Tip Comments Tip Rating

	Add titles to your chart in Excel To add titles to your Excel chart, select the chart and select Chart Options from the Chart menu. Choose the Titles tab at the top. From this page you can add a title for your chart and a separate title or label for each Axis.
	Save Tip Comments Tip Rating

	Quickly adding numbers in Excel To add a selection of numbers in Excel, just select them with the mouse. The sum of the numbers selected will be displayed in the status bar at the bottom of the screen. By right clicking on the word SUM in the status bar, you can change the formula used to Count, Average and a number of others.
	Save Tip Comments Tip Rating

	Paste a range name into an Excel formula To paste a range name into an Excel formula (and therefore remove any opportunity for error and save a lot of time), simply press F3 when creating the formula. The paste name dialog box appears and allows you to select the relevant range name and paste it straight into the formula.
	Save Tip Comments Tip Rating

	Making an Excel cell reference absolute To make an Excel cell reference absolute rather than relative, you need to add a dollar sign before the column and/or row reference. To do this automatically, click into the cell reference in the formula bar and press F4. If you select more than one cell reference in a formula, all selected parts will become absolute. If you press F4 repeatedly, you will see that Excel toggles through the four stages of absolute/relative references.
	Save Tip Comments Tip Rating

	Excel´s ADDRESS function - What does it do? Excel´s ADDRESS function creates a cell reference as text, given specified row and cell numbers. If cell A1 contains 15 and cell B1 contains 10, then: =ADDRESS(A1,B1) would return $J$15.
	Save Tip Comments Tip Rating

	Excel´s FIND function - What does it do? Excel´s FIND function searches for text you specify inside another text string and returns the position at which the text string starts. One standard use for this function is to look for a the position of a space when separating text strings (generally in conjunction with either MID or LEFT).
	Save Tip Comments Tip Rating

	Excel´s CODE function - What does it do? Excel´s CODE function returns a numeric code for the first character in a text string. If cell A1 contains Michael Gurner, then: =CODE(A1) returns 77.
	Save Tip Comments Tip Rating

	Uses for the F6 key in Excel In Excel, the F6 key moves you to the next pane of a split window. Shift - F6 moves you to the previous pane of a split window. Ctrl - F6 moves you to the next open workbook. Ctrl - Shift - F6 moves you to the previous open workbook.
	Save Tip Comments Tip Rating

	Uses for the F12 key in Excel In Excel, the F12 key activates the Save As dialog box. Shift - F12 activates the Save command. Ctrl - F12 activates the Open command. Ctrl - Shift - F12 activates the Print command.
	Save Tip Comments Tip Rating

	Chart non-adjacent data in Excel It´s common to want to produce an Excel chart that shows only some of your data, but you don´t need to rearrange or manipulate your data to achieve this. To select non-adjacent data (for example rows 2, 4 and 6 of your data), select the first required row, hold down the Ctrl key and select the second, then the third etc. Then create the chart in the usual manner.
	Save Tip Comments Tip Rating

	The Excel fill handle can be dragged up and left too! Most people are aware that the Excel Fill Handle (the black square in the bottom right hand corner of a selected cell) can be dragged to the right and down to extend a formula. What most people aren´t aware of is that you can also drag the Fill Handle to the left and up (just be careful to drag far enough, otherwise you´ll just delete the contents of the cell).
	Save Tip Comments Tip Rating

	Move to the end of an Excel row with the mouse Want to move to the end of an Excel row of data with the mouse? Double click on the right (or left) hand side of a cell.
	Save Tip Comments Tip Rating

	Excel´s LEFT function - What does it do? Excel´s LEFT function returns a number of characters that you specify from a text string, starting from the first character. If cell A1 contains Hello, then: =LEFT(A1,3) would return Hel (the first 3 characters within that cell).
	Save Tip Comments Tip Rating

	Moving to the end of a column of data in Excel To move to the last cell which contains data in an Excel column, double click on the bottom of the cell. To move to the end of a row, double click on the right hand side of the cell.
	Save Tip Comments Tip Rating

	Extending numerical sequences in Excel If you need to enter numerical sequences that follow a logical order (such as 1, 2, 3 or 5, 10, 15), Excel can save you a great deal of time and trouble. If you enter the first two numbers, Excel can complete the series for you. If you enter 1 in cell A1 and 2 in cell B1 and select both cells with the mouse. Then click and drag the fill handle to the right. Excel will continue the series as far as you drag.
	Save Tip Comments Tip Rating

	Show all Excel chart information without a legend You can remove the Excel Chart Legend and still make your chart readable. To do this, select your chart and select Chart Options from the Chart Menu. Select the Legend tab from the top and uncheck the box that says Show Legend. Now select the Data Labels tab from the top and select Show Label, then click OK.
	Save Tip Comments Tip Rating

	Quick AutoSum in Excel To save Excel asking you which data you want to autosum, simply select the data and press the AutoSum button. Excel will automatically sum the data.
	Save Tip Comments Tip Rating

	Get creative with Excel charts While the default Excel charts look professional in an OK sort of way, you can add a bit of life and colour to charts using Fill Effects. Double click an area of your chart (the background for example) and select Fill Effects from the Patterns tab. Experiment with some of the built in settings or create your own using your own pictures. Have fun.
	Save Tip Comments Tip Rating

	Excel´s MID function - What does it do? Excel´s MID function returns a number of characters that you specify from a text string, starting from a position which you specify. If cell A1 contains Michael Gurner, then: =MID(A1,4,7) returns hael Gu (seven characters, staring from character number 4).
	Save Tip Comments Tip Rating

	Selecting non-adjacent columns in Excel To select non-adjacent columns in Excel (as in columns A, C and G), click on the column header of the first column, hold down the control key and then click on the next header, then the next etc.
	Save Tip Comments Tip Rating

	Select an entire Excel worksheet To select an entire Excel worksheet, click the select all button, which can be found in the top left hand corner between the row and column headings.
	Save Tip Comments Tip Rating

	Show the data beneath the Excel chart Excel charts are sometimes easier to read if the reader has access to the data the chart represents. This can be added into the chart itself by following these simple steps. Select the chart and select Chart Options from the Chart menu. Click the Data Table tab at the top and click in the Show Data Table box. Click OK.
	Save Tip Comments Tip Rating

	Excel´s TRIM function - What does it do? Excel´s TRIM function removes all spaces from a text string except single spaces between words. If cell A1 contains Michael Gurner Is Great, then: =TRIM(A1) returns Michael Gurner Is Great.
	Save Tip Comments Tip Rating

	Excel´s T function - What does it do? Excel´s T function returns a text value if the cell contains text and a "" (empty text) if the cell does not contain text. If cell A1 contains Michael, then: =T(A1) returns Michael If cell A1 contains 247 (formatted as a number) then: =T(A1) returns "".
	Save Tip Comments Tip Rating

	Make an Excel chart easy to print To make your Excel chart easy to print, select the chart and choose Location from the Chart menu. Select the As New Sheet option and your chart will be reformatted to a sheet of its own and will be sized perfectly for printing.
	Save Tip Comments Tip Rating

	Excel´s CHAR function - What does it do? Excel´s CHAR function returns the ASCII character which conforms to a code number which you specify (between 1 and 255). If A1 contains 116, then: =CHAR(A1) Returns t.
	Save Tip Comments Tip Rating

	Select all data in an Excel table To select all data within an Excel table, click anywhere within your table, hold down the Ctrl key and press * (on the numeric keypad). You can also use Ctrl, Shift 8.
	Save Tip Comments Tip Rating

	Scrolling through Excel worksheets To scroll through the worksheets of the active Excel workbook, hold down the control key and press page down. To scroll in the other direction, hold down control and press Page up.
	Save Tip Comments Tip Rating

	Insert an Excel column To insert a new column in an Excel worksheet, select the column header where you want the new column to appear, hold down the control key and press + (on the numeric keypad).
	Save Tip Comments Tip Rating

	Uses for the F7 key in Excel In Excel, the F7 key activates the spelling command. Ctrl - F7 allows you to move the current window.
	Save Tip Comments Tip Rating

	Uses for the F4 key in Excel In Excel, the F4 key repeats the last action you carried out. Shift - F4 repeats the last Find you carried out (Find Next). Ctrl - F4 closes the current workbook. Alt - F4 exits the application.
	Save Tip Comments Tip Rating

	See what your data will look like in an Excel chart When selecting the type of Excel chart to use, it can be difficult to visualise what the chart will look like with your data in it. To see your chosen chart type with your data, click and hold the button at the bottom of the Chart-Type dialog box which says Press and hold to view sample.
	Save Tip Comments Tip Rating

	How can I modify an Excel chart once I´ve created it? Once you´ve created an Excel chart, the four steps of the Chart Wizard can be accessed from the Chart Menu (the chart menu only appears when you select the chart, if teh chart isn´t selected, you will see the Data menu instead). The first four options under the Chart menu are the four steps - Chart Type, Source Data, Chart Options and Location. Any of these can be edited at any time.
	Save Tip Comments Tip Rating

	Adjust Excel column widths To adjust the width of an Excel column, click on the right hand edge of the column header and drag to the desired width. A tool tip will appear and will tell you the exact width currently selected.
	Save Tip Comments Tip Rating

	Excel´s SEARCH function - What does it do? Excel´s SEARCH function searches for a text string within another text string and returns the position at which it finds it. If cell A1 contains Michael Gurner and cell B1 contains Gur, then: =SEARCH(B1,A1) Would return 9.
	Save Tip Comments Tip Rating

	Insert the current time quickly in Excel To quickly insert the current time into an Excel cell, hold down the control and shift keys and press ; (semi-colon).
	Save Tip Comments Tip Rating

	Don´t change the default alignments in Excel Excel sometimes gets confused as to whether a cell contains text or numbers. The default alignment for text is left and for numbers it is right - this makes it very easy to see if a cell or cells are not formatted as the correct type. I´d suggest that wherever possible you leave the defaults as they are.
	Save Tip Comments Tip Rating

	Uses for the F9 key in Excel In Excel, the F9 key calculates all the sheets in all open workbooks. Shift - F9 calculates the active worksheet. Ctrl - F9 minimises the active workbook.
	Save Tip Comments Tip Rating

	Automatically format based on the value in an Excel cell Why waste time looking for cells which meet certain criteria? Excel can be set up to format something in a particular way only if the cell meets certain conditions. To apply a conditional format, select the cells that you want to apply the formatting to and choose conditional formatting from the format menu. Set the criteria (as in B6 is greater than 15) and create a format to apply when that condition is met. By selecting add from the conditional formatting dialog box, you can create up to three conditions for each cell or group of cells.
	Save Tip Comments Tip Rating

	Excel´s RIGHT function - What does it do? The RIGHT function returns a number of characters from a text string that you specify starting from the last character. If cell A1 contains Michael Gurner, then =RIGHT(A1,4) returns rner
	Save Tip Comments Tip Rating

	Excel´s PROPER function - What does it do? Excel´s PROPER function converts text (of any case) to proper case (where the first letter of every word is capitalised). If cell A1 contains michaEl gUrner, then =PROPER(A1) returns Michael Gurner
	Save Tip Comments Tip Rating

	Excel´s EXACT function - What does it do? Excel´s EXACT function compares two text values and returns TRUE if they are identical and FALSE if they are not identical. If cell A1 contains Hello and cell B1 contains hello, =EXACT(A1,B1) will return FALSE because the Hello in A1 has a capital letter.
	Save Tip Comments Tip Rating

	Selecting an entire row with the keyboard in Excel To select an entire row in Excel, click anywhere inside the row, hold down the Shift key and press the Spacebar.
	Save Tip Comments Tip Rating

	Delete an Excel column To delete an Excel column quickly, select the column, hold down control and press - (minus)
	Save Tip Comments Tip Rating

	Uses for the F5 key in Excel In Excel, the F5 key activates the GoTo box. Shift - F5 activates the Find dialog box. Ctrl - F5 Restores the window size.
	Save Tip Comments Tip Rating

	Quickly apply a standard date format in Excel To apply a standard date format in Excel, select the cell(s), hold down Ctrl and press #.
	Save Tip Comments Tip Rating

	Save time on data entry in Excel If you find yourself typing the same information a number of times in the same column, Excel has a really useful ´pick from list´ feature which can save you loads of time. If you right click the Excel cell where you want to enter data, there is an option called Pick From List. This will bring up a list of all entries above the cell (in the same column) and you can select the relevant one. The same thing can be achieved by holding down the Alt key and pressing the down arrow. Please note - neither of the above will function correctly if there are blank rows in your data.
	Save Tip Comments Tip Rating

	Edit the active cell using the keyboard in Excel To edit the active Excel cell using the keyboard, press F2. This can save a lot of time switching between mouse and keyboard.
	Save Tip Comments Tip Rating

	Activate the Paste Function tool from the keyboard in Excel If you´re not sure of which Excel function to use, click in the cell where you want the answer, hold down the Shift key and press F3. The Paste Function tool will be activated.
	Save Tip Comments Tip Rating

	Excel´s UPPER function - What does it do? Excel´s UPPER function converts a text string to Uppercase. If cell A1 contains MicHAel gurneR, then: =UPPER(A1) returns MICHAEL GURNER.
	Save Tip Comments Tip Rating

	Excel´s REPLACE function - What does it do? Excel´s REPLACE function allows you to replace part of a text string with another text string. If cell A1 contains Michael Gurner and Cell B1 contains Mike, then