I have values on my worksheet in column A. I want to capture from column A the contents on the left before the first space. Below are some examples. Do you have a formula for this? It's okay if the formula looks at only cell A1. I can copy the formula down to capture everying on column A.
CarMax_TOT Special CarMax_TOT
Today don't go to work Today