• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

calling all programmers


Political User
Hi guys. I was wondering if anyone at OSNN is a excel macro wiz, or php, etc.

This is what I have:
Date Time Type Field1 Field2
May 17 6pm practice 3 & 4 1

Id like it to read:
May 17 6pm practice 3 & 4 Field1
May 17 6pm practice 3 & 4 Field2

Any suggestions? Quick and painless? or excessively complicated?



I may actually be insane.
Literally like that? Just text separated by spaces? Little more info, or even the file the info is coming from would be handy :)


(value not set)
Staff member
Political User
I tried to write a program one time. It was a .bat file that had this in it, "shutdown -s". I lost several friends over it after putting it in their startup folder. I then tried to sell them the antidote, which was "shutdown -a". That didnt go over very well :(
Last edited:
Is this all? or am i missing something in the question?

Just change the format type on the cells to date with the format you want.

Arggh, I see. Set the language on the cell format to English united states, offers more options than canadian.

Or did you want to ditch the - between month and day too?
And did you want it to automatically fill in the playing field name based on something else.

All of the above can be done pretty easily. Let me know.


Last edited:


Political User
no no no
sorry guys.
i have a HUGE list of data. i just posted one row in the excel file.

I need to make a macro to do this, i assume.

It seems logical. Heres how i break it down...
On a particular day there are x amounts of games to be played. And there are x amount of field. i need the data in a format i can easily drop into a database.

gameday match1-----match2----match3----match4
(edit: i dont know how to make a table in a post! sorry!!)

to be read into the db, i need it like:

gameday - match1 field1
gameday - match2 field2
gameday - match3 field3
gameday - match4 field4

so, IF their are 4 matches on 4 fields, then i need to insert X-1 rows. 3 new rows. and then i need the field names to move almost like a transpose.

sorry, i wasnt clear at all.

hope this help
Last edited:

Members online

No members online now.

Latest posts

Latest profile posts

Perris Calderon wrote on Electronic Punk's profile.
Ep, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there https://tinyurl.com/ycpxl
Electronic Punk wrote on Perris Calderon's profile.
All good still mate?
Hello, is there anybody in there? Just nod if you can hear me ...
What a long strange trip it's been. =)

Forum statistics

Latest member