advertisement
Forums

The Forum is sponsored by 
 

AAPL stock: Click Here

You are currently viewing the Tips and Deals forum
Any way to copy a column of numbers from Pages doc?
Posted by: rgG
Date: March 05, 2018 09:21AM
So, I have a Pages document.
It has an item description then three cost columns after the description, like below:

Two Stuart Devlin English Silver Novelty Eggs $450.00 $45.00 $405.00

All are tabbed columns. I need to copy just the last column of numbers so I can paste them into something like a Numbers spreadsheet so I can get a total. I can't figure out how to just copy that one column, unless I copy and paste each entry individually and I can just add them up with a calculator faster than doing that.

There are maybe 500 items that I need to get that last row of numbers from.

Any help will be appreciated. I just can't seem to figure out an easy way to do this.





Roswell, GA (Atlanta suburb)
Options:  Reply • Quote
Re: Any way to copy a column of numbers from Pages doc?
Posted by: Fred_Also
Date: March 05, 2018 09:38AM
Just copy the all the columns - description & $ figures.

Open a new Numbers doc and paste. Put a total on the required column.

Fred



Edited 1 time(s). Last edit at 03/05/2018 09:40AM by Fred_Also.
Options:  Reply • Quote
Re: Any way to copy a column of numbers from Pages doc?
Posted by: rgG
Date: March 05, 2018 09:40AM
Quote
Fred_Also
Just copy the whole columns - description & $ figures.

Open a new Numbers doc and paste. Put a total on the required column.

Fred

I'll give that a try. Thanks


Edit:
Well, that didn't work because the columns don't line up. I had to create this from a PDF that was converted via OCR and the columns were off, so when I straighten them out, they apparently are not formatted correctly to paste into a Numbers spreadsheet. Only the description column lines up. Ugh





Roswell, GA (Atlanta suburb)



Edited 1 time(s). Last edit at 03/05/2018 09:45AM by rgG.
Options:  Reply • Quote
Re: Any way to copy a column of numbers from Pages doc?
Posted by: Mr Downtown
Date: March 05, 2018 10:01AM
It seems like the only place the dollar sign occurs is at the beginning of a price column. So find every $ and replace it with <tab>$. Then copy and paste the text into a spreadsheet. The price columns should line up.
Options:  Reply • Quote
Re: Any way to copy a column of numbers from Pages doc?
Posted by: rgG
Date: March 05, 2018 10:03AM
Quote
Mr Downtown
It seems like the only place the dollar sign occurs is at the beginning of a price column. So find every $ and replace it with <tab>$. Then copy and paste the text into a spreadsheet. The price columns should line up.

Thanks!
Maybe that will work.





Roswell, GA (Atlanta suburb)
Options:  Reply • Quote
Re: Any way to copy a column of numbers from Pages doc?
Posted by: rgG
Date: March 05, 2018 10:13AM
Quote
Mr Downtown
It seems like the only place the dollar sign occurs is at the beginning of a price column. So find every $ and replace it with <tab>$. Then copy and paste the text into a spreadsheet. The price columns should line up.

OK. I am a real newb to Pages and I can do the find and replace thing, but I get this and when I paste it into Numbers it is just like before. I know you probably mean that I need to insert a Tab but I am not doing something right. Sorry for having no clue. Lol


Hermes Handbag <tab>$2,000.00 <tab>$200.00 <tab>$1,800.00





Roswell, GA (Atlanta suburb)
Options:  Reply • Quote
Re: Any way to copy a column of numbers from Pages doc?
Posted by: Mr Downtown
Date: March 05, 2018 11:19AM
Most programs require a special way to indicate things like tabs and returns in search & replace boxes. ^t is common to several programs for indicating a tab. I'd probably do the search-and-replace in a text editor like TextEdit, TexEdit, or TextWrangler—but Pages itself is probably easy enough.

If you want to just send me the file, I'll try to send you back a spreadsheet.
Options:  Reply • Quote
Re: Any way to copy a column of numbers from Pages doc?
Posted by: rgG
Date: March 05, 2018 11:38AM
Quote
Mr Downtown
Most programs require a special way to indicate things like tabs and returns in search & replace boxes. ^t is common to several programs for indicating a tab. I'd probably do the search-and-replace in a text editor like TextEdit, TexEdit, or TextWrangler—but Pages itself is probably easy enough.

If you want to just send me the file, I'll try to send you back a spreadsheet.

Thanks, I’ll try those, they might be easier.
I added the pages up manually, but if I have time, I can futz around and get a spreadsheet, then I can use that to double check my work.





Roswell, GA (Atlanta suburb)
Options:  Reply • Quote
Re: Any way to copy a column of numbers from Pages doc?
Posted by: Article Accelerator
Date: March 05, 2018 04:10PM
Select all the relevant text in Pages, paste it into TextEdit, then do this:

[www.mactricksandtips.com]

(This technique for vertical text selection works in Word too.)



Edited 1 time(s). Last edit at 03/05/2018 04:11PM by Article Accelerator.
Options:  Reply • Quote
Re: Any way to copy a column of numbers from Pages doc?
Posted by: rgG
Date: March 05, 2018 04:21PM
Quote
Article Accelerator
Select all the relevant text in Pages, paste it into TextEdit, then do this:

[www.mactricksandtips.com]

(This technique for vertical text selection works in Word too.)

Wow, that seems perfect. I will try that as soon as I get home. Thanks so much.





Roswell, GA (Atlanta suburb)
Options:  Reply • Quote
Re: Any way to copy a column of numbers from Pages doc?
Posted by: rgG
Date: March 05, 2018 07:08PM
Quote
Article Accelerator
Select all the relevant text in Pages, paste it into TextEdit, then do this:

[www.mactricksandtips.com]

(This technique for vertical text selection works in Word too.)

That worked like a charm. Now that I think about this, I believe I had known about this a long time ago, but forget. Thank you so much.

BTW, after putting the column of numbers in Numbers, my manual calculation was verified as correct. grinning smiley





Roswell, GA (Atlanta suburb)
Options:  Reply • Quote
Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 219
Record Number of Users: 52 on November 20, 2014
Record Number of Guests: 2330 on October 25, 2018