User Tools

Site Tools


microsoft_excel:delete_all_text_after_the_first_instance

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
microsoft_excel:delete_all_text_after_the_first_instance [2020/11/15 20:54] – created petermicrosoft_excel:delete_all_text_after_the_first_instance [2021/08/04 13:48] (current) – removed peter
Line 1: Line 1:
-=LEFT(A1,FIND(",",A1)-1)  
  
-will remove all text after the first comma in Cell A1.  
microsoft_excel/delete_all_text_after_the_first_instance.1605473675.txt.gz · Last modified: 2020/11/15 20:54 by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki