|
|||
|
Hi,
Take a look at the following Microsoft Excel Tips: Extract the first word in a cell in Microsoft Excel See Microsoft-Links.com for more tips and tutorials! Cheers! Last edited by WolfGirl : 12-14-2007 at 09:39 PM. |
|
|||
|
Hi,
Take a look at the following Microsoft Excel Tips: How to extract a file name from a path in Microsoft Excel See Microsoft-Links.com for more tips and tutorials! Cheers! Last edited by WolfGirl : 12-14-2007 at 09:39 PM. |
|
|||
|
Hi,
Take a look at the following Microsoft Excel Tips: Counting how many times specific character appears in cell in Microsoft Excel See Microsoft-Links.com for more tips and tutorials! Cheers! Last edited by WolfGirl : 12-14-2007 at 09:40 PM. |
|
|||
|
Hi,
Take a look at the following Microsoft Excel Tips: Convert text to lower case in Microsoft Excel See Microsoft-Links.com for more tips and tutorials! Cheers! Last edited by WolfGirl : 12-14-2007 at 09:40 PM. |
|
|||
|
Hi,
Take a look at the following Microsoft Excel Tips: Using the Validation Input Message as a Cell Comment See Microsoft-Links.com for more tips and tutorials! Cheers! Last edited by WolfGirl : 12-14-2007 at 09:41 PM. |
|
|||
|
To extract characters from text, use Text category formulas......
Extracting Characters from Text Using Text Formulas See Microsoft-Links.com for more tips and tutorials! Cheers! Last edited by WolfGirl : 12-14-2007 at 09:42 PM. |
|
|||
|
To apply formatting only to cells containing text, use the Conditional Formatting technique......
Applying Formatting Only to Cells Containing Text See Microsoft-Links.com for more tips and tutorials! Cheers! Last edited by WolfGirl : 12-14-2007 at 09:43 PM. |
|
|||
|
To find or find and replace in one sheet.....
Finding/Finding & Replacing in a Single Sheet or in All Sheets See Microsoft-Links.com for more tips and tutorials! Cheers! Last edited by WolfGirl : 12-14-2007 at 09:43 PM. |
|
|||
|
By selecting cells that only contain text, you can distinguish between cells containing different types of data, which allows you to delete, fill or lock cells by type.....
Selecting cells that only contain Text in Microsoft Excel See Microsoft-Links.com for more tips and tutorials! Cheers! Last edited by WolfGirl : 12-14-2007 at 09:44 PM. |
|
|||
|
Hi,
Take a look at the following Microsoft Excel tips: Merging and Centering with a Toggle Button in Excel 2002 and Excel 2003 See Microsoft-Links.com for more tips and tutorials! Cheers! Last edited by WolfGirl : 12-14-2007 at 09:44 PM. |
![]() |
| Thread Tools | |
| Display Modes | |
|
|