Counting # of characters before a certain character
=VALUE(LEFT(A1,FIND("-",A1)-1))
--
John C
"NickPro72" wrote:
Here is my example:
1 - fksdlafjd
2 - dklsafj
3 - lkdfjad
......
....
10 - salkjdfjdsl
11 - dklsafjsdj;lfdf
I am trying to grab the beginning # and put it in a different cell. This is
the formula that I am trying: =value(left(cell_ref,??????)). This is not
working for me. Any other ideas?
|