Ask Your Question

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

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

gregors gravatar image

updated 2020-08-16 12:43:07 +0200

Alex Kemp 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

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

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

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

JohnSUN gravatar image

Fastest way (using the mouse only)

numbers and letter.gif

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 4,087 times

Last updated: Dec 02 '14