Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a spreadsheet with column B having integers. I want to get the first digit of each entry in column B in the corresponding row of column C.

share|improve this question
    
By integers, do you mean there are some negative values? – Excellll Jul 14 '12 at 4:35

If you want them as numbers for calculation to be done

=VALUE(LEFT(B1,1))

drag that down in Column C else

=LEFT(B1,1)
share|improve this answer

To build on @datatoo's answer, if your list includes negative values, you'll have to add a condition to look past any negative signs:

=VALUE(IF(B1<0,MID(B1,2,1),LEFT(B1,1)))
share|improve this answer
1  
you COULD just take the absolute value of the cell first. abs() – lornix Jul 14 '12 at 20:10
    
@lornix Or that.... :P – Excellll Jul 15 '12 at 4:59

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .