Stars?

  • Thread starter Thread starter Scottmk
  • Start date Start date
S

Scottmk

Hello,
I imported some data into excel. One of the columns lists stars as
rating. I need to convert the stars into numbers. 1star=1, nothin
complicated. The problem is that the cell reads with an apostrophe an
then a "U" with mark over it. The mark kind of looks like a fla
tilda. So if it had four stars in the cell it would read in th
formula bar 'UUUU. All the U's would have little marks over them. An
ideas would be greatly appreciated.
Thanks,
Scot
 
Presumably you could use =len(a1) where a1 is the cell address i
question
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top