Simple formula

dione · Mar 25th, 2002, 01:25 PM

I have a series of numbers such as 2223333 in a column. I need to display the first 3 digits in a second column eg 222. What formula do I use?

[ This Message was edited by: dione on 2002-03-25 12:26 ]

Barrie Davidson · Mar 25th, 2002, 01:26 PM

Quote:

On 2002-03-25 12:25, dione wrote:
I have a series of numbers such as 2223333 in a row. I need to display the first 3 digits in a second cell eg 222. What formula do I use?

You can use =LEFT(A1,3). If you want it to be a number, not a string, use =VALUE(LEFT(A1,3))

Regards,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 01:25 PM	#1
dione New Member Join Date: Mar 2002 Posts: 3	I have a series of numbers such as 2223333 in a column. I need to display the first 3 digits in a second column eg 222. What formula do I use? [ This Message was edited by: dione on 2002-03-25 12:26 ]