excel sheet 2007

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

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

Cheers


See More: excel sheet 2007

Report •


#1
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:

=MID(B1,2,1)

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question