Hi All,
Iam new to excel. please give me solution for the below problem. I have a data
Guru123
Abhishek Mittal456
Rajesh Bucha1
Chethana HM356
Cristy Kuriakose98
JYOTI JODHANI23
SOURAV HALDER43
Ankush Gupta123456
SHANKAR SARKAR789
Sajith Sasidhar4567
Mitrani Banerjee89
MOHIT BAID1012
SHANKAR SARKAR11412
VARUN ANIRUDHAN4567
NAVEEN KUMAR M G98163
DEBORITA SAHA 12346
SHANKAR SARKAR12366
Shivani Rungta1245
And also note that length of Character keeps variying .
Example : I want the output like below :
Abhishek Mittal
Rajesh Bucha
SHANKAR SARKAR
Bookmarks