I have a string which reads like
1. PVR - Bangalore - Koramangala - Audi 5 - 300 seats
2. PVR - Delhi - Saket - Audi 2 - 100 seats
I want to create two unique codes, one for Row 1 and another for Row 2.
Is there a way that excel can automatically generate a numeric code for the entire row based on the text that it has?
So next time I get a row which reads:
3. Star Plus - All India - Sas Bahu Show - 30 Million viewers , I get a numeric number for this ?
1. PVR - Bangalore - Koramangala - Audi 5 - 300 seats
2. PVR - Delhi - Saket - Audi 2 - 100 seats
I want to create two unique codes, one for Row 1 and another for Row 2.
Is there a way that excel can automatically generate a numeric code for the entire row based on the text that it has?
So next time I get a row which reads:
3. Star Plus - All India - Sas Bahu Show - 30 Million viewers , I get a numeric number for this ?