General discussion on OpenOffice Calc and its spreadsheets.
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?
Ricky G. Marion
- Posts: 25
- Joined: Mon Mar 24, 2014 6:33 am
with 300 @ 499x in A1 B1 = left(A1;3), repeat as needed
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: No registered users and 0 guests