SPREADHSEET TIPS & TRICKS: Left & Right...

The left and right functions allow you to extract a specified number of characters from a data field in Excel. For example, the below screenshot shows a time series data dump of currency rates, dates and times from Reuters. The date field has come in the format DD/MM/YY HH:MM:SS. You may wish to separate the date from the time in this field. One way to do so is to use the Left and Right Functions, as per the screenshots below…

As shown, the “left” function was used in column G to extract the date from column A and the “right” function was used in column H to extract the time.