Finding characters in Excel cells — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Finding characters in Excel cells

by on
in Excel Training,Office Technology

Q. How can I return characters to the left of a dash in an Excel cell using the LEFT function? I don’t always know what position it will be in.

A. The LEFT function has two arguments: The cell reference you want the function to evaluate and the number of characters to return. However, if you don’t know how many characters to return, you need a second function, FIND. So, in this example, using FIND we know the location of the dash. Subtract 1 from this number and we have the number of characters to return on the left.

Leave a Comment