Can I remove "n" characters from the start of a series of entries?

use another column to get the right portion of the contents of the cells with the original entries.

Assuming the data is in column A

you can get the length of the string (the count of the characters) by using the function:

=len(A1)

you can get the right most 10 characters of the string in column A using the formula:

=right(A1, 10)

in each case you want to get the right most length minus three characters-- assuming there are no more than 99 songs.

The most general solution locates the position of the space (which separates the numbers from the song title).

Column B contains the fixed titles

B1=RIGHT(A1,LEN(A1)−FIND(" ", A1))

this is shorthand for, select cell B1, then type (or copy and paste from here) the formula:

=RIGHT(A1,LEN(A1)−FIND(" ", A1))

select cell B1, copy

select column B, paste

you can move the contents of column B by select the cells, then copy

select the destination

then use the menu item "Edit > Paste Formula Results"

🙂

If your numbers are always two digits, you can select the cells containing the tunes and run this simple script (copy-paste into Script Editor, in Applications > Utilities, and click run). No need to mess with formulas and extra columns. (But try on a test column first to make sure it's doing what you want).

SG

tell application "Numbers"

tell front document to tell active sheet

set t to first table whose selection range's class is range

repeat with c in t's selection range's cells

set c's value to (c's value as string)'s text 4 thru -1

end repeat

end tell

end tell

Hi BelaBartok,

This will work with leading two-digit numbers followed by a space (three characters total):

Formula in B2 (and Fill Down)

=RIGHT(A2,LEN(A2)−3)

Please call back if you have more than 99 tunes on a list 🙂.

Regards,

Ian.