Save time by using Excel's Left string functions

Save time by using Excel's Left string function

Did you know…that you can save time by using Excel's Left string functions?!?!

 

 

For Example: Monthly Material Accruals

If you only want to see a list of contacts and not the charge number:

=LEFT(H2,5)

When data is imported or copied into an Excel spreadsheet unwanted characters or words can sometimes be included with the new data.

Excel has several functions that can be used to remove such unwanted characters. Which function you use depends upon where the unwanted characters are located.

·        If you have unwanted characters on both sides of your good data, use the MID function to remove them.

·        If these unwanted characters appear on the left side of your good data, use the RIGHT function to remove them.

·        If the unwanted characters are on the right side of your good data, use the LEFT function to remove them.

The LEFT Function

The syntax for the LEFT function is:

= LEFT (Number, Num_chars)

Number - the piece of data you want to change.

This can be a cell reference indicating where the data is stored.

Num_chars - specifies the number of characters to be retained from the Number specified above