This question already has answers here: Remove part of string after “.” (6 answers) Closed 8 years ago. I have a data set wherein a column looks like this: ABC|DEF|GHI, ABCD|EFG|HIJK, ABCDE|FGHI|JKL, DEF|GHIJ|KLM, GHI|JKLM|NO|PQRS, BCDE|FGHI|JKL …. and so on I need to extract the characters that appear before the first | symbol. In Excel, we […]