• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating unique identifier for each string

Samcho

New Member
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 ?
 
Back
Top