title: Excel 2007 - Generate unique ID based on text?
body: <p>I have a sheet with a list of names in Column B and an ID column in A. I was wondering if there is some kind of formula that can take the value in column B of that row and generate some kind of ID based on the text? Each name is also unique and is never repeated in any way.</p>
  
  <p>It would be best if I didn't have to use VBA really. But if I have to, so be it.</p>