How can we treat Christopher as chis or Chris while filtering any excel file?
Any updates on this issue? i need to implement it urgently
I think you can filter the data just by contains - chris, and the results will have all 3 variants: Chris, chris, Christopher.
Hi, But this will not work in case of Jessie vs Jesse/ Mohammad vs md.
Try using advanced filter in Excel