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

[Sanjit_Pal]

Hey @Snow,

Follow the below steps:-

1. ForEachRow activity
   2.Assign activity
   Left = item(“Grade”)
   Right = item(“Grade”).ToString.Split(";"c)(0).Trim.ToString

Thanks,
Sanjit