Extract Text from Cell Help
This should be a simple one but I can't get my head around this formula...
The cell contains the following text:
F0101 - 370001234
I would like to extract into a different cell all characters before the first " ". In this instance it is F0101.
Where I am struggling is because the text I want to extract varies in number of characters. For example, it could be:
GHA750WR - 370001234
In the above example I would want the cell to display GHA750WR.
I appreciate any support you can give with this.
Help Article Resources
Check out the Formula Handbook template!