Removing partial text from a cell
I have a column of text as the examples below where I need to remove the dates at the end. The dates are all different - I just need to remove the text from the "/" onwards. Any ideas?
374 GF A1 to A4 Evap Flometer Pipe / 18 Feb 2021
377 No. 4 Thick Juice tank / 10 Feb 2021
Thanks for reading!
Help Article Resources
Check out the Formula Handbook template!