EXCEL: How to extract text before a comma, space or period [SOLVED]
If you try to extract text before a space ” “, comma “,” or period “.” in Excel you may try something along these lines:
However, if you have non-matching records, i.e. something without a space in the previous example then you will get the following result:
Since that is probably not what you wanted, try the following:
Which will result in either (A) the shortened result (where applicable) or (B) the original data (which did not have a space in the first place).
Here is an example of the formula in action: