• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

Pull Characters Before Specific Character

I have a values like this:

CISCO2611XM-DC | Network Hardware Resale

in a column

I need to pull out everything before the |

If there is no | I want to leave the cell blank.

How can I do this
0
cstormer
Asked:
cstormer
1 Solution
 
nutschCommented:
Try this:

=iferror(left(a1,find("|",a1)-1),"")
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