export/convert text from a numbers doc?

[Boomish69]

I have a column of text in Numbers which I want to copy the text from but can't seem to do it, does any one know how?

EG I have 4 columns in numbers the first is full of text with Artist names , I want convert the fist column to a text doc like artist1-artist2-artist3 etc

spent hours trying to find something on the web & copy & trying in pages & numbers..

Appreciate any advice.

 

[kryten2]

I have a column of text in Numbers which I want to copy the text from but can't seem to do it, does any one know how?

EG I have 4 columns in numbers the first is full of text with Artist names , I want convert the fist column to a text doc like artist1-artist2-artist3 etc

spent hours trying to find something on the web & copy & trying in pages & numbers..

Appreciate any advice.

Have you tried selecting the first column --> copy --> open TextEditor --> paste --> Make Plain Text --> save your txt file. You can also try something like this :

AppleScript Editor :

tell application "Numbers"
	-- insert actions here
	set mySheet to get active sheet of first document
	
	tell mySheet
		tell table 1
			-- Change the range to match your first column
			set selection range to range "A2:A108"
			set myValues to value of every cell of selection range whose value is not missing value
		end tell
	end tell
	
end tell

set AppleScript's text item delimiters to return
set contentToDump to myValues as string
set AppleScript's text item delimiters to ""

-- An ArtistNames.txt file will be created on your Desktop with the Artist names in it.
do shell script "echo " & quoted form of contentToDump & " > ~/Desktop/ArtistNames.txt"

 

[saberahul]

If your first column is:
Header
Artist 1
Artist 2
Artist 3

And you want:
Artist 1 - Artist 2 - Artist 3

Then you can create a formula in another blank cell with:
= A1 & " - " & A2 & " - " & A3

And then copy that cell and paste into a text document.

If you have a lot of rows, you can do the same as above, but:
Type in B1:
= A1 & " - "
Type in B2:
= B1 & " - "
Drag down (gold icon in bottom middle of B2) to fill all cells in column
Select last cell in column B and paste in text document like textEdit
Remove the very last hyphen

 

[Boomish69]

ahhhhhhh what amazing replies thank you so much, trouble is I stupidly spent hours copying & pasting them one by one
I knew there'd be a solution, I just tried it in text edit and posting with match style removes the table leaving the text hooray! At least I know now when I need to update it.

Thank you both so much..I can't tell how much time I wasted on this one tiny silly thing.