Ask Your Question

how to delete a word from a spreadsheet

asked 2017-04-13 10:56:38 +0200

paulrooms gravatar image

updated 2017-12-10 17:05:00 +0200

erAck gravatar image

I have a column with data like 80 sales, 50 sales, 70 sales .... and so on. How can I delete the word "sales" from the whole spreadsheet and keep the numbers?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2017-04-13 11:07:13 +0200

karolus gravatar image


→Edit→Find and replace … " sales" →→ nothing

edit flag offensive delete link more

answered 2017-04-13 11:05:12 +0200

updated 2017-04-13 11:27:06 +0200

Ciao, follow my scrennshots, please.

If my answer helped you, vote it with ✔ (here on the left)

image description

image description

edit flag offensive delete link more

answered 2017-04-13 11:23:36 +0200

Lupp gravatar image

updated 2017-04-13 11:50:33 +0200

You can use 'Find & Replace' with regular expression in the way demonstrated in this attachment. The example can be modified in many ways to serve under variant conditions.
You may also want to have a look into this second example drawing your attention to a basically different solution (though not literally matching the OQ).

edit flag offensive delete link more


My soluton may look unnecessarily complicated as compared with the concise answers posted in advance (without my notice). However, This is due to my attempt to also handle complications often occurring without being mentioned by a questioner ("quiet" spaces here).
I have to concede, on the other hand, that it will not handle non-integer numerical content without any adaption - as the solutions by my two friends do.

Lupp gravatar imageLupp ( 2017-04-13 11:31:34 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-13 10:56:38 +0200

Seen: 195 times

Last updated: Apr 13 '17