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.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/34247/finding-characters-in-excel-cells "