General discussion
June 13, 2005 at 02:51 AM
ivan the terrible

Convert text in a call to a number

by ivan the terrible . Updated 21 years, 3 months ago

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 discussion is locked

All Comments