Ahb Merch.. Again.. Simple Really!

Australia & New Zealand Homebrewing Forum

Help Support Australia & New Zealand Homebrewing Forum:

This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.
Update:

Printing is done, so will start posting out Tee only orders today and tomorrow.

Quick Q for any excel wizards:

I want to print labels and the addresses are in one cell separated with comma's, eg:

Ian Kitten, 14 Porkspin Lane, Tarragoon, NSW 8455

Is there an easy formulae that I could use to put them into cells going down?

As in:

Ian Kitten
14 Porkspin Lane
Tarragoon, NSW, 8455


Cheers
 
Update:

Printing is done, so will start posting out Tee only orders today and tomorrow.

Quick Q for any excel wizards:

I want to print labels and the addresses are in one cell separated with comma's, eg:

Ian Kitten, 14 Porkspin Lane, Tarragoon, NSW 8455

Is there an easy formulae that I could use to put them into cells going down?

As in:

Ian Kitten
14 Porkspin Lane
Tarragoon, NSW, 8455


Cheers

Dunno if this helps, but you can split them into colums using:

Data> Text to Columns. Choose Delimited. Check Comma box. Choose the destination for the first cell to display the address horizontally.

That will put the addresses in different cells, then you just use those cells when you mail merge to your labels.
 
good work cocko! this will put the address on 3 lines in one cell
do a find/replace on the comma before the state and replace it with nothing: replace ", NSW" with " NSW". do it for each state
do another find/replace for a comma and a space, and replace with a CR symbol (hold down alt and press 0 then 1 then 0 release alt)

edit: retarded
 
Cheers lads, address/label thing sorted....



Tee shirt only orders are in the post: Registered;

Beerdrinkingbob
Schooey
big78sam
Stef
lagers44
Winkle
OLDS2006
keifer33
BigDaddy
Flavo
Cruiser351
pimpsqueak
enuun
Mearesy
Stux
Lemon
itmechanic
ScottC
Silo_Ted
pmunny
Liam_snorkel
bluebetty
Paul_H
iJosh
Dazdog
crazyhorse
stagger
The_Drunk_Arab
peakydh
Kaiser_soze
ratchie
Snowdog
The_dragon


The rest will go out once the embroidery is finished....


Stay tuned.
 
Good to see those of us who bought one of each are getting rewarded :(

All good! Thanks for posting these so quick Cocko, can't wait to wear my gear proudly around the office.
 
Hey Clints the embroidery always takes longer than printing that's why tees will go first. Better to get some
Out the door early then have to send all in one hit.
 
Yeah I know i'm just taking the piss pok. It doesn't make sense to have everyone wait, and it just means you've got to post more stuff in one go.
 
Mine arrived today. Thanks gents
 
Who's going to model their shirts ? Im going to shrink mine so its five sizes too small, then squeeze myself into it.

Cheer for making this happen. Will check my PO box on Saturday

3799482999_e70bc13934.jpg
 
Prick.




BTW: Where is the other AHB Merch thread? from this run, lets not trash this one and keep it to updates and any problems people have.

HaHa, sorry mate but I felt it was my best chance to get you at your own game. Post is deleted.
 
HaHa, sorry mate but I felt it was my best chance to get you at your own game. Post is deleted.


No sorry's, You should be proud, It was absolute top shelf, a class spinning mate, lets not be mistaken *wipes tear* I am like a proud father...eheh...


ANYWAY: BACK OT PLEASE!

Seriously, otherwise if this thread comes up people may not check it... and they need to.

Where is the AHB t shirts thread we can continue to trash??


ALL NON SPINNERS: Please stay tuned for updates on orders and post here once yours arrived for my and poks own piece of mind...

Cheers
 
Who's going to model their shirts ? Im going to shrink mine so its five sizes too small, then squeeze myself into it.

Cheer for making this happen. Will check my PO box on Saturday

3799482999_e70bc13934.jpg

My man boobs are bigger :D
 
Ian Kitten
14 Porkspin Lane
Tarragoon, NSW, 8455

3799482999_e70bc13934.jpg


But why did you have to use my real name, address and photo as an example? :(
 
I cant wait to get mine! But I guess it will take a week or so from experience
Thank you guys even though your porkspins have been putting me on the spot at the office
 

Latest posts

Back
Top