How to Take first 3 numbers of a cell to another cell ?

General discussion on OpenOffice Calc and its spreadsheets.

How to Take first 3 numbers of a cell to another cell ?

Postby Ricky G. Marion » Fri Aug 29, 2014 4:47 am

Hello,

I have some cells which have for instance
300 @ 499x
and I want to read the original cells first three numbers (the 300 in this case) and use that in another cell to operate on it (leaving the original cell intact), is there an easy way to do this?

Thanks,
Ricky G. Marion
 
Posts: 25
Joined: Mon Mar 24, 2014 6:33 am

Re: How to Take first 3 numbers of a cell to another cell ?

Postby Brian L. Chacon » Fri Aug 29, 2014 7:49 am

Hello,

with 300 @ 499x in A1 B1 = left(A1;3), repeat as needed

Thanks,
Brian L. Chacon
 
Posts: 20
Joined: Mon Mar 24, 2014 6:23 am


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: Google [Bot] and 1 guest

cron