Search and replace in a column in Numbers?

Question

Level 1

4 points

Search and replace in a column in Numbers?

Hi,

I have spreadsheet with columns containing text and columns containing numbers. I want to replace a string in one of the columns, but not in the others. I couldn't find out how to do that.

What I'm actually trying is to import a CSV file that formats numbers using a point, like so:

"This column contains some text.","0.12","some more".

Numbers can't seem to interpret the number as such, and doesn't allow me to switch the column format to Number. So I want to replace the point with a comma (the decimal point in my locale).

Thanks for any advice

Posted on Jan 29, 2023 10:09 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,214 points

Jan 29, 2023 04:25 PM in response to st3b0

st3b0 wrote:

found the shortcut. Not sure if I'm going to use it though. I'd really like to see it as a feature of Numbers.

If you pin it to the menu bar and/or attach it to a keyboard shortcut it's almost as if it were a built-in feature of Numbers.

It can be inspected and downloaded here:

https://www.icloud.com/shortcuts/221b9fc7dcbb4171ac2c6575418a362d

However, you can always make a suggestion to Apple via Numbers > Provide Numbers Feedback in your menu.

SG

Reply

Answer 2

Badunit

Level 7

29,910 points

Jan 30, 2023 06:11 PM in response to st3b0

When in the Shortcut App, drag and drop it on "Menu Bar".

It will end up in the shortcut menu on the right side of the menu bar

Reply

Answer 3

SGIII

Level 8

37,214 points

Jan 30, 2023 07:46 PM in response to st3b0

Or with the Shortcut open in the Shortcuts app click the circled i at the upper right and check 'Pin in Menu Bar' (and/or choose other options convenient to your workflow).

SG

Reply

Answer 4

Badunit

Level 7

29,910 points

Jan 29, 2023 01:31 PM in response to st3b0

SGIII has a solution. I'm sure it will be posted here soon or you can search for it from an older thread. Find Replace in Selection.

Reply

Answer 5

st3b0 Author

Level 1

4 points

Jan 29, 2023 03:30 PM in response to Badunit

Thanks. I found the shortcut. Not sure if I'm going to use it though. I'd really like to see it as a feature of Numbers. I added a column instead and did the find and replace through a formula.

Reply

Answer 6

st3b0 Author

Level 1

4 points

Jan 30, 2023 09:05 AM in response to SGIII

Then I have another question. I couldn't find out how to pin the Shortcuts app to the menu bar. Could you give me one more hint? Thanks, best

Reply

Search and replace in a column in Numbers?

Similar questions