General discussion

Locked

Convert text in a call to a number

By Ivan the Terrible ·
I have an excel spreadsheet that has a column which can have one of three text words entered ?Windows, UNIX or Hardware?.

I want to find a way to convert those three words into numbers so I can automatically generate a total amount in a separate column.

Example: If I have the word ?Windows? entered 3 times in this column, I want it to calculate this so changing my Windows Total column to 3.

My Excel formula skills are rather limited, so if more info is required let me know.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums