Tag Archives: excel

How to remove first, last or certain characters from text in Excel?

Remove the first four characters from the text string.Step 1. Type the following formula in adjacent cell B1: =RIGHT(A1, LEN(A1)-4), Source: How to remove first, last or certain characters from text in Excel?

Posted in Compus | Tagged

How to convert date to number or text in Excel?

Select a cell next to your date data, and type this formula =TEXT(A1,”dd/mm/yyyy”) into it, then press Enter key. If you need, you can drag the fill handle to apply this formula in a range. Source: How to convert date … Continue reading

Posted in Compus | Tagged , ,

Using Dynamic Chart Titles (Microsoft Excel)

There is a very cool way, apparently not well known, of adding ‘active’ or ‘live’ titles and other text to charts. In this way you can make a change in a worksheet and have that change reflected in a title … Continue reading

Posted in General | Tagged ,