How to split and read only part of date

[mwscott1]

I am pulling from an excel file and for the Identity column I only need the name out of the data for each record

Example:

Server/Accounts/Users/John Doe\1645587952551528449

All I need is the John Doe.  All entries are the same except the name and quid at the end are different for each user.

[Gysbert_Wassenaar · Accepted solution]

subfield(subfield(MyFieldHere,'/',4),'\',1)

[its_anandrjs]

Hi,

If name position is fixed then use =mid(ColA, 23, len(ColA)  -  42)

Thanks & Regards