Custom functions in Excel to manipulate text
|
| Excel formulas do more than make it easy to work with numbers. You can also use formulas to correct or rearrange text without retyping. This is especially handy after you've imported a large text file that needs to be cleaned up. You can use formulas to add or remove capitals, delete extra spaces, combine information from two cells into one, and separate some of the information from one cell into another. You can also compare cell contents without proofreading. |
|
|
| Custom text functions in excel- continued |