Hi everyone, I'm trying to format numbers in a cell into words. For example, if I type 1 in a cell, I would like it to show the word Optimistic. If i type 2 in the cell I would like it to show the word "Realistic", 3 to show "Pessimistic".
How would I be able to do that?
Thank you!
It's a bit heavy handed but you could put things in the autocorrect table that would do this, BUT!!!!
Click * below if this answer helped
You can try this formula
=LOOKUP(A1,{1,2,3},{"Optimistic","Realistic","Pessimistic"})
Optimistic Realistic Pessimistic Optimistic Pessimistic
However, if you have more values it would be better to create a lookup table and use formula like VLOOKUP
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
I thought of lookup and vlookup, but thought that tonylyx wanted the result in the same cell as he entered the number.
Yea I recalled a friend showed me that there was a way in Format Cell, we could write formula that could turn certain numbers into text .. Like [1 = "Optimistic"].. but can't remember exactly what the formula was
Originally Posted by tonylyx
Yea I recalled a friend showed me that there was a way in Format Cell, we could write formula that could turn certain numbers into text .. Like [1 = "Optimistic"].. but can't remember exactly what the formula was
Just figured it out! It's [=1]"Optimistic";[=2]"Realistic";"Pessimistic"Thanks guys
Try entering 1,2 or 3 into the attached workbook.
Please Login or Register to view this content.
@Xx7
It looks like it is going to do that in any cell. Should there be a reason for concern?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks