Chris Stormer
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.