How to keep only the first character in an excel table?

Hi @Snow , welcome to the community.
I am attaching a workflow for your reference which might help you to get your solution. Also, sending the sample excel file.
Grade.zip (7.3 KB)

Have a nice day!

Thanks & Regards,
Shubham Dutta