There are numerous document editing tools on the market, but only some are compatible with all file formats. Some tools are, on the contrary, versatile yet burdensome to use. DocHub provides the solution to these issues with its cloud-based editor. It offers powerful capabilities that allow you to accomplish your document management tasks efficiently. If you need to quickly Cut first name in ME, DocHub is the best option for you!
Our process is incredibly simple: you import your ME file to our editor → it instantly transforms it to an editable format → you make all required changes and professionally update it. You only need a couple of moments to get your work done.
After all adjustments are applied, you can transform your paperwork into a reusable template. You just need to go to our editor’s left-side Menu and click on Actions → Convert to Template. You’ll locate your paperwork stored in a separate folder in your Dashboard, saving you time the next time you need the same form. Try out DocHub today!
to extract the first names from these names listed here in the formula bar equal text before function open parenthesis first argument of text before function is text select the cell containing name comma second argument delimiter specify the delimiter separating the first middle and last names here space is that delimiter double quote space double quotes close parenthesis enter and we have the first name extracted into the cell lets copy this formula into the cells below