finding values to left

Hi Expert's excel 2007

I am using mid(a1,search("#",a1)+1,len(a1))
Which gives my the right value of 2543566#576457
how do I get the left part 2543566 .
route217Asked:
Who is Participating?
 
SreeramConnect With a Mentor Commented:
Hi

try this

LEFT(A1,search("#",a1)-1)
0
 
route217Author Commented:
Excellent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.