I want to search a row E for some text of variable length but always starting with the same "NNN-MMM" and populate column A with this text

Are you struggling to extract specific text from column E that starts with "NNN-MMM" and populate column A with it? This common challenge can hinder your productivity, but with the right formula, you can streamline the process effortlessly. In this guide, we’ll walk you through creating a formula that efficiently searches for variable-length text in column E and populates the corresponding cells in column A. Stay tuned to discover a straightforward solution that enhances your spreadsheet capabilities and saves you valuable time.