I know there must be an excel expert on here:
Here goes:
We have a column of names like:
John
Mary
Joe
And we need to make them look like this:
John
John
Mary
Mary
Joe
Joe
This would be ideal but we could also work with:
John
Mary
Joe
(adding a space between entries)
This is just for one column not the whole excel file.
:drunk3:
Of course the end of the world depends on this problem. Don't they all
i think tpat turned me on to this a while back
http://csved.sjfrancke.nl/ (http://csved.sjfrancke.nl/)
i dont think it will do what you want, but it does work magic on other tasks.
A quick solution. Insert a new column after ColumnA. Copy ColumnA to ColumnB. Copy both columns and paste into a text editor (I prefer TextWrangler on OSX). Replace all tab characters with a return character (in TextWrangler it would be \t for tabs and \r for return). Copy and paste back into excel and delete the ColumnB that you made earlier.
thanks, interesting concept.
my nephew actually helped me with this one, he gave me a little macro:
Sub DoubleNames3()
Dim iRow As Integer
Dim lastName As String
Range("a1").Select
iRow = 1
Do
Cells(iRow + 1, 1).Insert shift:=xlDown
Cells(iRow + 1, 1).Value = Cells(iRow, 1).Value
iRow = iRow + 2
Loop While Not Cells(iRow, 1).Text = ""
End Sub
which worked. thank god my sister was smart and bore this child!
Ah, the proverbial nephew. "We didn't need a graphic desinger because my nephew can do it for free" :laugh: I hope you get his files someday!
"This is so simple a child of 7 could do it"
" Run out and find me a child of 7"
:lmao:
fuck excel
This one works better:
Sub DoubleNames4()
Dim iColumnNumber As Integer
Dim iRepeatTimes As Integer
Dim iRepeatCount As Integer
Dim iRow As Integer
' Run the Error handler "ErrHandler" when an error occurs.
On Error GoTo Errhandler
' THIS CONTROLS THE POPUP DIALOGS THAT ASK FOR USER INPUT
iRepeatTimes = InputBox("Enter times to repeat:", "Collect User Input")
iColumnNumber = InputBox("Enter column number (A = 1, B = 2...):", "Collect User Input")
' THIS IS THE STARTING ROW... CHANGE THIS TO 1 IF NO TITLES ROW
iRow = 2
Do
iRepeatCount = 1
Do
Cells(iRow + iRepeatCount, iColumnNumber).Insert shift:=xlDown
Cells(iRow + iRepeatCount, iColumnNumber).Value = Cells(iRow + iRepeatCount - 1, iColumnNumber).Value
iRepeatCount = iRepeatCount + 1
Loop While (iRepeatCount < iRepeatTimes)
iRow = iRow + iRepeatTimes
Loop While Not Cells(iRow, iColumnNumber).Text = ""
End
Errhandler:
' If an error occurs, display a message and end the macro.
MsgBox "Sorry, An error has occurred. The macro will end."
End Sub
Quote from: DigiCorn on March 10, 2014, 08:07:49 AMfuck excel
I dunno...for spreadsheets & stuff it works great! You know, what it's intended for.
Quote from: gnubler on March 10, 2014, 12:59:45 PMQuote from: DigiCorn on March 10, 2014, 08:07:49 AMfuck excel
I dunno...for spreadsheets & stuff it works great! You know, what it's intended for.
Yuuuuuup!
Fuck Publisher.
Quote from: born2print on March 10, 2014, 01:16:49 PMFuck Publisher.
That I can agree with, in any capacity.
Especially when it's used for "publishing". :laugh:
Quote from: gnubler on March 10, 2014, 12:59:45 PMQuote from: DigiCorn on March 10, 2014, 08:07:49 AMfuck excel
I dunno...for spreadsheets & stuff it works great! You know, what it's intended for.
Not for insane works of Japanese art? (http://www.mymodernmet.com/profiles/blogs/tatsuo-horiuchi-excel-spreadsheet-paintings) :thumbsup:
There is a Fn CONTEST?
QuoteExcel Autoshape Art Contest
one would think our customers participated in it, especially from some of the excel files I get...
not too arty, but large intricate works of something.
half of the world's automation is feeding on excel files. I'm in Prepress, how the hell did i get into this?
:drunk3: (probably bad karma for drinking too much).
:drunk3:
today i say, fark powerpoint.
get a job from a hotel chain, not mentioning which one but one of the founders decendents has the first name of the capital of france.
so first they send their graphics standards manual in.... very professional. outlines pms and cmyk numbers that must be followed. in comes the file ... 4/4 flyer done in powerpoint, no bleeds, rgb crap.
after arguing with the boss.... and spending 3 hours basically rebuilding the file, its approved! quantity 100, delivery in 2 days.
cost to bill about 80 dollars.
they are happy with the work we did. i guess so, who else would be :drunk3: stupid enough to do it for them. :drunk3:
That's alright pspdfppdfx, at least now they think their crappy files "work just fine"
THANKS! :sarcasm: :laugh:
Quote from: born2print on March 17, 2014, 03:38:29 PMThat's alright pspdfppdfx, at least now they think their crappy files "work just fine"
THANKS! :sarcasm: :laugh:
Yep...and they will tell the next printer, "My last printer didn't have any problem with it". :shoots_self:
have the customer print it out how they want it to look, and then just scan it
Quote from: born2print on March 17, 2014, 03:38:29 PMThat's alright pspdfppdfx, at least now they think their crappy files "work just fine"
THANKS! :sarcasm: :laugh:
Yeah, well, despite ardent protests before hand, the guy who signs the paycheques told me to do it.
:drunk3:
Quote from: pspdfppdfx on March 18, 2014, 10:38:27 AMQuote from: born2print on March 17, 2014, 03:38:29 PMThat's alright pspdfppdfx, at least now they think their crappy files "work just fine"
THANKS! :sarcasm: :laugh:
Yeah, well, despite ardent protests before hand, the guy who signs the paycheques told me to do it.
:drunk3:
Oh yeah, that's understood, just like :drunk3: :drunk3: :drunk3:
:hello:
Did you ever figure out how to insert alternating blank rows in Excel? Here's a link.
http://www.pcmag.com/article2/0,2817,1785247,00.asp (http://www.pcmag.com/article2/0,2817,1785247,00.asp)
Didn't actually need to do this trick but thanks anyways.
You are Excel-erating my knowledge of Excel! Might need it one day.
:drunk3:
Yea, that one's handy :)
For Monday:
I have an excel file that has what looks like glyphs as separators
can anyone tell me how to convert this over?
I tried saving as txt and open in excel and using fixed widths- no worky
Quote from: Tracy on December 12, 2014, 05:06:08 PMFor Monday:
I have an excel file that has what looks like glyphs as separators
can anyone tell me how to convert this over?
I tried saving as txt and open in excel and using fixed widths- no worky
Can you send me the excel file to take a look at?
linked it to you
I guess if I can figure out how to type tab I can find replace
but I can't get the tab into replace
Tracy,
It appears they used the | key to place between the fields. (Vertical bar key right above the return key on the Mac keyboard.) I was able to do a search & replace in Open Office calc searching for regular expressions as show here:
[attachimg=1]
Then I saved a Tab delimited text file (.csv) and also saved an open office calc file (.odt). They are attached. See if any of that helps. If you need another type of file or if for some reason these won't work let me know and I'll try something else.
Thanks Joe!
The guy at the mail house showed me how you can
do it by going to text to columns and selecting other
and typing the character, it was above the slash key
above the Return
I think your way is easier! :wink:
:-[ I just saw that you did it in open office :laugh:
It can be done in excel also. I just don't happen to have it here at home.
Also if you need an excel file just open or import (not sure which applies for Excel) the .csv file and tell it the field separator is a TAB and it should display correctly in Excel.
Quote from: pspdfppdfx on March 17, 2014, 03:20:43 PMcost to bill about 80 dollars.
they are happy with the work we did. i guess so, who else would be :drunk3: stupid enough to do it for them. :drunk3:
That's why I'm out and why all the printers keep collapsing like a row of drunken dominoes.
Gnubler's back! :banana:
Hey Gnubler, everything Ok with you!