Tag Archives: text

MS Access: Left Function

Syntax The syntax for the Left function in MS Access is: Left ( text, number_of_characters ) Parameters or Arguments text The string that you wish to extract from. number_of_characters Indicates the number of characters that you wish to extract starting … Continue reading

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 , ,