Editing OTT is fast and simple using DocHub. Skip installing software to your computer and make adjustments with our drag and drop document editor in a few fast steps. DocHub is more than just a PDF editor. Users praise it for its convenience and powerful features that you can use on desktop and mobile devices. You can annotate documents, create fillable forms, use eSignatures, and send documents for completion to other people. All of this, put together with a competing price, makes DocHub the perfect option to expunge last name in OTT files with ease.
Make your next tasks even easier by turning your documents into reusable templates. Don't worry about the safety of your data, as we securely store 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