Data Analyst and Technical Consultant

Five Excel String Functions

Here are five more useful functions to make life easier in Excel.  This time we’ll look at string functions for dealing with text and start to explore date functions.

RIGHT, LEFT, MID

These three functions are used to pull out certain parts of the cell without having to do this one by one.

=LEFT(I2,4)

Left finds the cell entered and returns the number of characters requested to the left of the first character, in this case, four.

 

=RIGHT(I3,4)

Right finds the cell entered and returns the number of characters requested to the right of the last character, in this case, four.

 

=MID(I4,5,5)

Mid finds the cell entered and returns the number of characters requested from the start point given, in this case, five characters from point five.

Remember if you haven’t used the TRIM first, any trailing spaces will be included.

 

more-useful-formulas2

 

TODAY

Useful for a countdown or if you want to use it to calculate the number of days between the current date and an order date.

=TODAY()

 

more-useful-formulas3

 

MAX and MIN

=MIN(H2:H17)

To find the lowest value in a range of cells, use the MIN function. For example, this formula will find the lowest value in cells H2:H17.

 

=MAX(H2:H17)

To find the highest value in a range of cells, use the MAX function. For example, this formula will find the highest value in cells H2:H17

 

more-useful-formulas4