Excel formulas or macros
I have 2 columns of text that I want to covert or show in a new column as a number. ss A would = 17, SI A = 18 and SF = 0 how would I do that?
ss A
ss A
si C
sf I
ss A
si C
ss C
Attachment | Size |
---|---|
Book1.xlsx | 9.4 KB |
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 629 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Excel formulas or macrosI have 2 columns of text that I want to covert or show in a new column as a number. ss A would = 17, SI A = 18 and SF = 0 how would I do that? ss A
|
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
Hi, This can be done by a
Hi,
This can be done by a formula. If the text is in column A and starts at the first row, you can use something like this:
=if(A1="ss A",17,if(A1="si C",18,if(A1="sf I",0,"")))