Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 151
  • Last Modified:

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 .
0
route217
Asked:
route217
1 Solution
 
SreeramCommented:
Hi

try this

LEFT(A1,search("#",a1)-1)
0
 
route217Author Commented:
Excellent
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now