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/

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

@minhhuyen172002 - Fri Jul 07 2023 10:16:01 GMT+0000 (Coordinated Universal Time)

=RIGHT(A2,LEN(A2)-SEARCH("-",A2))

More like this

Excel

@minhhuyen172002

Fill in blanks in Excel with value Excel substring functions to extract text from cell

Browse more snippets >>