Wiki

User Tools

Site Tools

Trace: • delete_all_text_after_the_first_instance
microsoft_excel:delete:delete_all_text_after_the_first_instance

Microsoft Excel - Delete - Delete all text after the first instance

Remove all text after the first comma in Cell A1. 

=LEFT(A1,FIND(",",A1)-1)
microsoft_excel/delete/delete_all_text_after_the_first_instance.txt · Last modified: 2021/08/04 14:49 by peter
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki