Excel substring functions to extract text from cell
Thu Jul 06 2023 09:13:42 GMT+0000 (Coordinated Universal Time)
Saved by @minhhuyen172002
=LEFT(A2, SEARCH("-",A2)-1)
https://www.ablebits.com/office-addins-blog/excel-substring-functions-extract-text/
Comments
@minhhuyen172002 - Fri Jul 07 2023 10:16:01 GMT+0000 (Coordinated Universal Time)=RIGHT(A2,LEN(A2)-SEARCH("-",A2))