Ask Your Question
0

In Calc, how do i retain only the numbers when a cell has numbers and letters [closed]

asked 2014-12-02 07:51:18 +0100

gregors gravatar image

I have a column with numbers and letters (volumes with units). I want to do calculations on the values. How do I remove the space and the units so only numbers remain? Example of some of the contents in the column:

3000 ml

750 ml

330 ml

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-06 21:58:48.281739

2 Answers

Sort by » oldest newest most voted
1

answered 2014-12-02 08:07:22 +0100

gregors gravatar image

Just use the Edit>Find & Replace function.

Select the column

Call the function from the menu or < Ctrl+H >

Input " ml" (with space but without " ) in the "Search for" field and insure that the "Replace with" field is empty (not even a space)

Press the " < Replace All >" button

edit flag offensive delete link more
0

answered 2014-12-02 10:27:26 +0100

JohnSUN gravatar image

Fastest way (using the mouse only)

numbers and letter.gif

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-12-02 07:51:18 +0100

Seen: 2,199 times

Last updated: Dec 02 '14