excel 2003 help please!

carlnash · 03-12-2009, 11:17 AM

I am a newbie excel user and I am having trouble figuring out what formula to use to achieve a desired result. I have a column of numbers, and I need to drop the last digit off of each number in the column. I know that using a formula like this: =LEFT(F2,LEN(F2)-1)
gives me the desired result on one value in the column (in this case the second value in column F), but I can't figure out how to apply a similar formula to the entire column.
Thanks for any help!

**Glaswegian** · 03-12-2009, 02:59 PM

Hi and welcome.

Assuming you want to apply this to the whole column, and you have data in the column to the left of your formula, click on the cell with the formula, move the mouse to the bottom right corner until the pointer changes to a small cross, then double click. Excel will fill in the formula down the column - the formula will also adjust for each new row.

Is this what you mean?

carlnash · 03-13-2009, 03:03 PM

Thanks! That was really easy, and it takes care of my problem. You have been a huge help!

03-12-2009, 11:17 AM	#1 (permalink)
carlnash Registered User Join Date: Mar 2009 Posts: 5 OS: xp	excel 2003 help please! I am a newbie excel user and I am having trouble figuring out what formula to use to achieve a desired result. I have a column of numbers, and I need to drop the last digit off of each number in the column. I know that using a formula like this: =LEFT(F2,LEN(F2)-1) gives me the desired result on one value in the column (in this case the second value in column F), but I can't figure out how to apply a similar formula to the entire column. Thanks for any help!

03-12-2009, 02:59 PM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,504 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: excel 2003 help please! Hi and welcome. Assuming you want to apply this to the whole column, and you have data in the column to the left of your formula, click on the cell with the formula, move the mouse to the bottom right corner until the pointer changes to a small cross, then double click. Excel will fill in the formula down the column - the formula will also adjust for each new row. Is this what you mean? __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

03-13-2009, 03:03 PM	#3 (permalink)
carlnash Registered User Join Date: Mar 2009 Posts: 5 OS: xp	Re: excel 2003 help please! Thanks! That was really easy, and it takes care of my problem. You have been a huge help! Last edited by carlnash; 03-13-2009 at 03:04 PM. Reason: typo