Excel Tips

=LEFT(<cn>,LEN(<cn>)-LEN(<hostname>)-1)

Example

=LEFT(D2,LEN(D2)-LEN(A2)-1)

This entry was posted in Journal and tagged . Bookmark the permalink.