Editing ODM is fast and simple using DocHub. Skip downloading software to your computer and make alterations with our drag and drop document editor in a few easy steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and robust features that you can use on desktop and mobile devices. You can annotate documents, create fillable forms, use eSignatures, and deliver records for completion to other people. All of this, put together with a competitive price, makes DocHub the ideal option to clean up last name in ODM files effortlessly.
Make your next tasks even easier by converting your documents into reusable templates. Don't worry about the security of your data, as we securely keep them in the DocHub cloud.
to extract the last name from these names listed here in the formula bar equal text after function open parenthesis first argument of text after 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 comma now the instance number we want the last name minus 1 close parenthesis end letamp;#39;s copy this formula into the cells below