Deleting specific parts of text in multiple cells, Numbers on Mac.

Question

Level 1

4 points

Deleting specific parts of text in multiple cells, Numbers on Mac.

I would like delete specific parts of text in multiple cells in Numbers on Mac.

Ive extracted a file from a different application that I would like to edit, with like 2000 rows. I would like to remove certain parts of the text in each cell without doing it cell by cell.

I want to remove everything behind SKXXXX(SK and the four numbers) So that shows up like it does in the first row.

Is there a way where I can do this more quickly so that it applies to all the rows.

MacBook Air (M1, 2020)

Posted on Feb 17, 2024 1:08 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,920 points

Feb 17, 2024 7:28 AM in response to marvefleks

Here are two ways, assuming the original is in A2.

If the number of characters before the - is always 6 then you can use in B2 or wherever:

=LEFT(A2,6)

and fill that down the column.

If the number of characters before the - might vary then you can use in B2 or wherever:

=TEXTBEFORE(A2,"-")

and fill that down the column.

Use ; instead of , in the formulas if your region uses , as the decimal separator.

SG

Reply

Deleting specific parts of text in multiple cells, Numbers on Mac.

Similar questions