excel sheet 2007

Microsoft Office 2007 home and student
May 13, 2010 at 23:58:01
Specs: Windows XP

I am trying to create formula to do the following

1 B1/88
1 B1/55
3 B3/33
3 B3/22

when i input data as above say B1/88 then in cell in front will show 1 and if i input B3 it should show 3, as i am only looking at second number not the Letter

Hope makes sense


See More: excel sheet 2007

Report •

May 14, 2010 at 08:27:51
If what you want is the Second Character from the string then try this:

In cell A1 enter the formula:




Report •
Related Solutions

Ask Question