Calling all Excel experts

Started by pspdfppdfxhd, June 25, 2010, 03:35:37 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages 1 2 3
User actions

DigitalCrapShoveler

#15
November 18, 2010, 01:17:20 PM
Quote from: Joe on November 18, 2010, 01:16:08 PM
Quote from: DigitalCrapShoveler on November 18, 2010, 01:07:14 PMNow Tracy is stealing my thunder! :laugh:

It's the new fad in town.

Evidently. :rolleyes:
Member #285 - Civilian

Sabrina The Turd Polisher

#16
August 26, 2011, 07:54:35 AM
HALP! I've got a mailing list that needs editing and I don't know to do it (except manually).

How do I make the years in the Year column read "2009" instead of "9"??

Ambidextrous, Double-jointed Prepress Slave
We all have issues. The only people that don't are the dead ones. ©2011 Joe  |  doomed ©2011 david

gnubler

#17
August 26, 2011, 08:04:08 AM
Find/Replace.
Hicks • Cross • Carlin • Kinison • Parker • Stone •  Colbert • Hedberg • Stanhope • Burr

"As much as I'd like your guns I prefer your buns." - The G

Quote from: pspdfppdfx on December 06, 2012, 05:03:51 PM
So,  :drunk3: i send the job to the rip with live transparecy (v 1.7 or whatever) and it craps out with a memory error.

Member #14 • Size 5 • PH8 Unit 7 • Paranoid Misanthropic Doomsayer • Printing & Drinking Since 1998 • doomed ©2011 david

Sabrina The Turd Polisher

#18
August 26, 2011, 08:19:01 AM
Quote from: gnubler on August 26, 2011, 08:04:08 AMFind/Replace.
I presume I can do F/R for just that column?
Ambidextrous, Double-jointed Prepress Slave
We all have issues. The only people that don't are the dead ones. ©2011 Joe  |  doomed ©2011 david

DigiCorn

#19
August 26, 2011, 08:31:06 AM
<-- NOT an Excel expert, but it seems to me that you can define a field as being a year and create a column to return a value expressed in such fashion. Try looking at the formula list and see if there's an option there.
"There's been a lot of research recently on how hard it is to dislodge an impression once it's been implanted in someone's mind. (This is why political attack ads don't have to be true to be effective. The other side can point out their inaccuracies, but the voter's mind privileges the memory of the original accusation, which was juicier than any counterargument ever could be.)"
― Johnny Carson

"Selling my soul would be a lot easier if I could just find it."
– Nikki Sixx

"Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut."
― Ernest Hemingway

gnubler

#20
August 26, 2011, 08:39:59 AM
You're over-thinking it, Corn.

Just highlight the entire column and F/R 9 to 2009
Hicks • Cross • Carlin • Kinison • Parker • Stone •  Colbert • Hedberg • Stanhope • Burr

"As much as I'd like your guns I prefer your buns." - The G

Quote from: pspdfppdfx on December 06, 2012, 05:03:51 PM
So,  :drunk3: i send the job to the rip with live transparecy (v 1.7 or whatever) and it craps out with a memory error.

Member #14 • Size 5 • PH8 Unit 7 • Paranoid Misanthropic Doomsayer • Printing & Drinking Since 1998 • doomed ©2011 david

Sabrina The Turd Polisher

#21
August 26, 2011, 10:26:56 AM
F/R did the trick. Thanks Gnub! Fixed the list in a quick minute.
Was talking to my Excel nerd friend earlier and she was talking about the way Digi mentioned.
Since I'm off the rest of the day...I no care until Monday.
Ambidextrous, Double-jointed Prepress Slave
We all have issues. The only people that don't are the dead ones. ©2011 Joe  |  doomed ©2011 david

gnubler

#22
August 26, 2011, 11:25:42 AM
I work in Excel/OO frequently (almost daily). I am no expert but I can help with the basics.
Hicks • Cross • Carlin • Kinison • Parker • Stone •  Colbert • Hedberg • Stanhope • Burr

"As much as I'd like your guns I prefer your buns." - The G

Quote from: pspdfppdfx on December 06, 2012, 05:03:51 PM
So,  :drunk3: i send the job to the rip with live transparecy (v 1.7 or whatever) and it craps out with a memory error.

Member #14 • Size 5 • PH8 Unit 7 • Paranoid Misanthropic Doomsayer • Printing & Drinking Since 1998 • doomed ©2011 david

Tracy

#23
August 26, 2011, 06:10:57 PM
I think when someone copies and pastes data into excel from some other file
makes the file bad for Data Merge
Im still checkin it out, but I could not get rid of those paragraph returns
with find/replace.
Im done with the job but I am determined to figure it out

Im gonna get an excel for dummies book :laugh:

Joe

#24
August 26, 2011, 06:43:22 PM
Quote from: Tracy on August 26, 2011, 06:10:57 PMI think when someone copies and pastes data into excel from some other file
makes the file bad for Data Merge
Im still checkin it out, but I could not get rid of those paragraph returns
with find/replace.
Im done with the job but I am determined to figure it out

Im gonna get an excel for dummies book :laugh:

Send me the file so I too can bang my head against a brick wall. :banghead:

 :laugh:
Mac OS Sonoma 14.2.1 (c) | (retired)

The seven ages of man: spills, drills, thrills, bills, ills, pills and wills.

gnubler

#25
August 26, 2011, 06:57:24 PM
Tracy, I will also look at it if you like. If you copy the data and do "Paste Special" choosing only 'text' or 'numbers' it strips other crap out. Easier to just look at it and see what's up.
Hicks • Cross • Carlin • Kinison • Parker • Stone •  Colbert • Hedberg • Stanhope • Burr

"As much as I'd like your guns I prefer your buns." - The G

Quote from: pspdfppdfx on December 06, 2012, 05:03:51 PM
So,  :drunk3: i send the job to the rip with live transparecy (v 1.7 or whatever) and it craps out with a memory error.

Member #14 • Size 5 • PH8 Unit 7 • Paranoid Misanthropic Doomsayer • Printing & Drinking Since 1998 • doomed ©2011 david

Tracy

#26
August 27, 2011, 09:08:20 AM
cool thanks guys!, Ill get it to you on monday!
paste special sounds interesting

David

#27
August 29, 2011, 07:44:12 AM
it's....  just so special
Prepress guy - Retired - Working from home
Livin' la Vida Loca

gnubler

#28
August 29, 2011, 08:49:14 AM
Like quark?
Hicks • Cross • Carlin • Kinison • Parker • Stone •  Colbert • Hedberg • Stanhope • Burr

"As much as I'd like your guns I prefer your buns." - The G

Quote from: pspdfppdfx on December 06, 2012, 05:03:51 PM
So,  :drunk3: i send the job to the rip with live transparecy (v 1.7 or whatever) and it craps out with a memory error.

Member #14 • Size 5 • PH8 Unit 7 • Paranoid Misanthropic Doomsayer • Printing & Drinking Since 1998 • doomed ©2011 david

David

#29
August 29, 2011, 08:53:16 AM
no, that's magical


 :wizard:
Prepress guy - Retired - Working from home
Livin' la Vida Loca
Print
Go Up Pages 1 2 3
User actions