How to get data the way I want it

iainmunro

New Member
Joined
Apr 20, 2011
Messages
24
Hi There

I have the following data that I am trying to get sorted into columns for importing into an SQL Table. The problem I am having is getting it to do this reliably.

I have tried Text to Columns as well as Pasting Special than transposing, but nothing is working.

As there is quite a bit of data, I am trying to do as much automatically as possible.

If anyone can help I would appreciate it.

Iain


Basil Ranch, Calgary
certified organic herbs
Cathie Hunter
403-283-9303
email: basilr@telus.net
Available at: The Cookbook Co. Cooks; Sunnyside Market; Lina’s Italian Market

Beck Farms, Innisfail
carrots, carrot pickles
Rod &Shelley Bradshaw
403-227-1020
www.innisfailgrowers.com
Available at: Edgar Farms farmgate store; The Jungle farmgate store; Innisfail Growers booth at The Calgary Farmers’ Market; Grassroots Northland Farmers’ Market; Millarville Farmers Market; other markets in season

The Blooming Fields, Didsbury
naturally raised fruit, vegetables, and berries using Integrated Pest Management (IPM)
Mary-Ann & Pim van Oeveren
403-335-8264
www.thebloomingfields.com
Available at: farmgate

Blue Mountain Biodynamic Farms, Carstairs
CSA, biodynamically raised certified-organic herbs, greens, vegetables, eggs, goats, house-milled flours and grains, frozen pork
Kris Vester & Tamara Brunt
403-337-3321
http://members.shaw.ca/bluemtnbio-dynamics/
Available at: SPUD, Sunnyside Market; Hillhurst Sunnyside Farmers’ Market; Farm Fresh Organics Home Delivery Ltd.

Broxburn Vegetables & Café, Lethbridge
berries & vegetables, greenhouse crops
Paul & Hilda de Jonge
403-327-0909
www.broxburn-vegetables.com
Available at: the farmgate, Kingsland Farmers’ Market; Lethbridge Farmers’ Market

Buckler Farm, Bottrell
pesticide-free fruit, berries, vegetables, CSA
Charlie Buckler
403-804-7315
www.bucklerfarm.ca
Available at: the farmgate; Twisted Basil, Cochrane

Bumbleberry Orchard Ltd., Strathmore
Naturally raised berries & fruit-berry wines
Elaine & Marvin Gill & Lorraine & Glen Ellingson
403-934-2749
www.fieldstonefruitwines.com
Available at: the farmgate, pre-pick & U-pick

Eagle Creek Farm – Bowden SunMaze, Bowden
flowers, heritage potatoes, garlic, vegetable CSA
John Mills, Terra Madre youth grower
403-224-3995
www.sunmaze.ca; www.eaglecreekfarms.ca
Available at: the farmgate; CSA subscription; Innisfail Growers booth at The Calgary Farmers’ Marke; Grassroots Northland Farmers’ Market; Millarville Farmers’ Market & other markets in season

Edgar Farms, Innisfail
asparagus, peas, preserves, frozen fruit pies, Angus beef
Elna & Doug Edgar
Keri & Randy Graham, Terra Madre youth growers
403-350-0659
www.edgarfarms.com; www.innisfailgrowers.com
Available at: the farmgate; Innisfail Growers booth at The Calgary Farmers’ Market; Grassroots Northland Farmers’ Market; Millarville Farmers Market; other markets in season

Gull Valley Greenhouse, Gull Lake
heirloom tomatoes, peppers, cucumbers, beans, lettuce, eggplant, herbs grown without pesticides
Scott Epple & Phil Tiemstra
403-969-1670
no website
Available at: Calgary Farmers’ Market; Edmonton Old Strathcona Farmers’ Market

Heritage Market Gardens, Vulcan
CSA, heirloom tomatoes, berries, herbs, vegetables grown without pesticides
Jim & Donna Graff
403-485-2998
no website
Available: the farmgate by appointment; central weekly delivery to subscribers

Hillside Greenhouses, Innisfail
greenhouse tomatoes and lettuce
Carmen & Jose Fuentes
402-224-2841
www.innisfailgrowers.com
Available at: Edgar Farms farmgate store; The Jungle Farmgate store; Innisfail Growers booth at The Calgary Farmers’ Market; Grassroots Northland Farmers’ Market; Millarville Farmers Market; other markets in season

Hotchkiss Herbs & Produce, Rocky View
organic heirloom tomatoes, greens, assorted vegetables
Paul & Tracy Hotchkiss
403-236-2963
www.hotchkissproduce.com
Available at: Amaranth Whole Foods Market; Blush Lane Organic Market; Community Natural Foods; The Cookbook Co. Cook;, Janice Beaton Fine Cheese; Lina’s Italian Market; Second to None Meats; Sunnyside Market; Walt’s Produce Sales; Valta Bison Farm; Highwood Natural Foods, High River; Twisted Basil, Cochrane

The Jungle Farm, Innisfail
berries, strawberries, unsprayed vegetables, pumpkins, flowers, melons (first season of growing), preserves, vinaigrettes, baked goods
Leona & Blaine Staples
403-227-4231
www.innisfailgrowers.com; www.thejunglefarm.com
Available at: the farmgate; Edgar Farms farmgate store; Calgary Farmers’ Market in the Innisfail Growers booth; Grassroots Northland Farmers’ Market plus many other farmers’ markets

Kayben Farms, Okotoks
black currants, strawberries, market garden vegetables, preserves, punch base, café, garden centre & greenhouse
Judy, Jolene, Stephanie & Claude Kolk
403-938-2857
www.kayben.com
Available at: the farmgate; Community Natural Foods; Savour Fine Foods; The Cookbook Co. Cooks; Valta Bison Farm; Chinook Honey Co., Okotoks; Gourmet on the Go, Okotoks

Lund’s Organic Produce, Innisfail
certified organic root vegetables, cabbage, greens
Gert & Betty Lund
403-227- 2693
www.lundsorganic.com
Available at: Kingsland Farmers’ Marke;, Calgary Farmers’ Market (until October 2010)

New Oxley Ranch, Claresholm
natural garlic & CSA pastured poultry raised without antibiotics
Jackie Chalmers
403-625-5270
email: Jackie_chalmers@hotmail.com
Available at: the farmgate by appointment; Paradise Hill Farm, Nanton

Paradise Hill Farm, Nanton
greenhouse tomatoes grown without pesticides
Tony & Karen Legault
403-646-3276
www.paradisehillfarm.ca
Available at: the farmgate; Calgary Co-op

Poplar Bluff Farm, Strathmore
certified organic heirloom potatoes, beets & carrots, parsnips, butternut squash
Rosemary Wotske & Cam Beard
403-934-5400
www.poplarblufforganics.com
Available at: Community Natural Foods; Amaranth Whole Foods Market; Planet Organic; Sunnyside Marke; Okotoks Natural Foods, Okotoks; Highwood Natural Foods, High River

Upper Green Farm, Innisfail
John & Cory Buyks
potatoes
403-227-4403
www.innisfailgrowers.com
Available at: Edgar Farms farmgate store; The Jungle Farmgate store; Innisfail Growers booth at The Calgary Farmers’ Market; Grassroots Northland Farmers’ Market; Millarville Farmers Market; other markets in season

meat

Applejack Ranch, Bashaw
natural grass-fed Dexter beef raised without hormones, lamb, pork, poultry
Marrianne Stevenson & Les Brunelle
403-788-2135, 1-866-708-2970
www.canadiandextercattle.com
Available at: farmgate
Available on the menu a: Apples Restaurant, Bashaw

Bar XT Ranch, Irvine
naturally raised red Angus beef, antibiotic & hormone free
Paul Von Huene
1-866-834-3414/ 403-834-2540
no website
Available at: the farmgate, or call Paul to arrange home delivery

Broek Pork Acres, Coalhurst
pastured natural Berkshire pork
Allan & Joanne Vanden Broek
403-381-4753
email: ajvandenbroek@telus.net
Available at: Rocky’s Sausage Haus; Second to None Meats

Buffalo Horn Ranch Olds
natural bison
Peter & Judy Haase
403-556-2567
www.buffalohornranch.ca
Available at: year-round limited selection at Eagle Hill Co-op; during summer, at Cochrane Farmers’ Market; Grassroots Northland Farmers’ Market; Bearspaw Farmers’ market. In off-market seasons, the Haase’s deliver, by pre-order only

Cakadu Heritage Lamb, Innisfail
Barbados Black-bellied lamb
Denis & Linda Jabs
403-728-2398
email: cakadu@telusplanet.net
Available at: the farmgate by pre-order

Canadian Rocky Mountain Ranch, DeWinton
elk & bison raised without hormones or antibiotics
Brad O’Connor & Dr. Terry Church
403-804-4183 Brad O’Connor; 403-256-1350 Dr. Terry Church
www.crmr.com
Available at: at farmgate; order online for pickup at Second to None Meats; CRMR at Home; Millarville Farmers’ Market

Diamond Willow Organics Ltd., Pincher Creek
certified organic beef
Keith Everts
403-627-1800
www.diamondwillow.ca
Available at: Save-On Foods; Community Natural Foods

Double N Ranch
c/o Aaron and Chelsea Cunningham
Box1 Site 14 RR 2*
Sundre, Alberta
*T0M 1X0

doublenranch@xplornet.com
chelsea@cowkid.ca
www.doublencattlecompany.com
Farm gate, deliveries to Calgary, Bergen Market in the summers, which is saturday mornings 9-12

Driview Farms, Fort Macleod
natural lamb
Gerrit & Janet van Hierden
403-553-2178
www.driviewfarms.ca
Available at: the farmgate; Bite Groceteria; Millarville Farmers’ Market; delivered in Calgary with no minimum charge if you meet Gerrit on his weekly delivery route

Eat Food For Life Canada (Terra Caritatis Patris Farm), Clandonald
cooperative of small family farms, meat-based CSA “The Meats Market”, dry aged grass fed beef, soy-free turkey and chicken, lamb, certified organic pork, mentorship for emerging family farms
Tim & Maighread Axe
780-853-6046
www.eatfoodforlife.ca
Available at: order online for pick up and delivery to Edmonton; Calgary delivery soon to come

Elbow Falls Wapiti, Priddis
natural elk
Win Niebler
403-931-2427
email: win.niebler@gmail.com
Available at: Community Natural Foods
Available on the menu at: Big Rock Brewery; La Chaumiere; Rouge; Bavarian Inn, Bragg Creek

Ewe-Nique Farms, Champion
natural lamb
Bert & Caroline Vande Bruinhorst
403-897-3737
www.eweniquefarms.com
Available at: Second to None Meats; The Better Butcher; SA Meats
Available on the menu at: Il Sogno; The Belvedere; District; Moti Mahal; Calgary Petroleum Club; Muse; AKA Wine Bar; Char|Cut Roast House; Phil & Sebastian`s Coffee House; Q Haute; Aida’s

First Nature Farms, Goodfare
Certified organic grass-finished Angus & Galloway beef, bison, pastured Berkshire pork, pastured chicken & turkey
Jerry Kitt
780-356-2239
www.firstnaturefarms.ab.ca
Available at: Community Natural Foods; Old Strathcona Farmers’ Market, Edmonton

Flying Heart Homestyle Beef, Strathmore
naturally-raised, drug- & hormone-free Angus beef
Beth & Rod Vergouwen
403-934-6228
www.flyingheart.ca
Available at: the farm gate, order online

Four Creeks Ranch, Silver Valley
Grass-fed certified organic bison
Ted Buchan
780-351-2115
no website
Available at: Old Strathcona Farmers’ Market, Edmonton under First Nature Farms label

Grazin Acres, Two Hills
natural lamb, pork, beef & certified organic poultry, eggs
John & Helene De Boer
1-888-657-2001
no website
Available at: Calgary Farmers’ Market; Dutch Treats & Farm Fresh Meats, Edmonton

Guitton Farms, Claresholm
certified organic beef, gluten-free salami
Dennis & Lorna Guitton
403-625-4732
www.guittonfarms.com
Available at: farmgate; Planet Organic; Amaranth Whole Foods Market; Lethbridge Farmers’ Market; Tail Blazers, Lethbridge; Highwood Natural Foods, High River

Highwood Valley Ranch, High River
hormone- and antibiotic-free Angus beef
Ralph & Jacqueline Nelson
403-652-7477
www.highwoodvalleyranch.com
Available at: the farmgate; Millarville Farmers’ Market; High River Farmers’ Market

Hog Wild Specialties, Mayerthorpe
wild boar meat products and hunting excursions
Earl & Deb Hagman
1-888-668-9453
www.hogwild.ab.ca
Available at: Second to None Meats; online;, Buffalo Valley Variety Meats, Edmonton
Available on the menu at: Bonterra; Sugo; River Café; La Chaumiere; Q Haute; The Glenmore Inn; Normand’s Fine Regional Cuisine, Edmonton; Jack’s Grill, Edmonton

Hoven Farms, Eckville
organic beef
Tim & Lori Hoven
403-217-2343
www.hovenfarms.com
Available at: Kingsland Farmers’ Market; Nutter’s Bulk & Natural Foods, Canmore; SPUD; Planet Organic
Available on the menu at: Infuse Catering & Forage Farm to Fork Foods to Go; Rocky Mountain Flatbread, Canmore; The Eddie Burger & Bar, Banff

Irvings Farm Fresh, Round Hill
natural pastured Berkshire pork, sausage, dry-cured smoked back and side bacon, pork products, on-farm processing
Alan & Nicola Irving
780-672-2787; cell 780-266-6651
www.irvingsfarmfresh.com
Available at: the farmgate; direct delivery to a central point; The British Pantry; Eat Local First (www.eatlocalfirst.com); Locavoria, Edmonton; Old Strathcona Farmers’ Market, Edmonton; Ed’s Gluten Free, Edmonton; The Grape Vine, St. Albert; plus others
Available on the menu at: numerous Edmonton restaurants

J and M Rabbit Farm, Lethbridge
rabbit, lamb, eggs
Jim & Margaret Oosterhof
403-317-0330
www.jandmfarms.com
Available at: the farmgate

LJ Ranch, Cochrane
natural grass-fed beef
Lindsay & Joy Eklund
403-932-7777
www.ljranch.ca
Available at: farmgate and online; steaks and sausage at Twisted Basil, Cochrane

Old Country Sausage Shop, Raymond & Lethbridge
Old World charcuterie made without fillers, MSG, sugar, dairy, nitrites, artificial colours or binders using Spring Creek beef, Alberta pork and house-raised lamb, custom sausage making
Klaus & Mary Lee Schurmann
403-752-3006 and 403-317-7977 (Lethbridge)
www.oldcountrysausages.com
Available at: shop in Raymond; shop in Lethbridge; Calgary Farmers’ Market; Janice Beaton Fine Cheese; Blush Lane Organic Market; Community Natural Foods
Available on the menu at: FARM; Wild Rose Brewery

Olson’s High Country Bison, Spread Eagle Ranch, Waterton
natural bison
Tom Olson
403-313-6200
no website
Available at: Kingsland Farmers’ Market; Community Natural Foods; Planet Organics; Sunnyside Market; Nutter’s Bulk & Natural Foods
Available on the menu at: River Café; Murrieta’s; The Post Hotel, Lake Louise

Oxyoke Farms, Linden
Natural meats; vegetables to CSA subscribers
Robby & Phyllis Fyn
403-546-0110
Available at: the farmgate; vegetables to CSA subscribers

Pine Terra Farm, Onoway
Certified organic grass-fed dry-aged black Angus beef
David & Louise Phillips & Nadine Waddell
780-967-3012
www.pineterrafarm.com
Available at: order online & deliver or meet; HomeGrown Foods, Stony Plain; Good Food Box, Edmonton; Community Natural Foods
Available on the menu at: River Café; Calgary Golf & Country Club; Sorrentino’s, Edmonton; Bistecca, Edmonton; Red Ox Inn, Edmonton; Café De Ville, Edmonton

Premium Organic Farms, Calgary
certified organic grass-fed beef & vegetables
Paul & Sheila Schneider
403-235-6000, 402-203-3695
www.premiumorganicfarms.ca
Available a: the farmgate

Pura Vida Farm, Lethbridge
grass-finished dry aged Angus beef & pastured heritage Freedom Ranger poultry, Food Alliance certified, hormone- and antibiotic-free
Wayne & Anne Wikkerink
403- 327-9947, cell 403-330-8877
www.pvbeef.com
Available at: the farmgate by appointment; Nutter’s Bulk & Natural Foods, Lethbridge

Ravenwood Farm Fresh Meats, Caroline
Farm, shop & café: hormone- and antibiotic-free Berkshire pork, in-house processing, natural meats from owners` ranch and neighbours including beef, poultry, bison, lamb, goat, rabbit, venison, veal, eggs, local ingredients
Mark & Tamara Taylor
403-722-2292; 403-722-4038 after hours
www.ravenwoodranch.com
Available at: shop and café; online ordering; Hillhurst Sunnyside Farmers’ Market; Red Deer Farmers’ Market
Available on the menu at: Baker Creek Bistro; Redstone Grill, Red Deer; Infuse Catering & Forage Farm to Fork Foods to Go

Ruzicka Sunrise Farm, Killam
free-range York and Landrace pork raised without hormones or antibiotics, certified organic pastured poultry, turkey and eggs, certified organic grass-finished Galloway, Angus and Red Poll beef
Don & Marie Ruzicka
780-385-2474
www.sunrisefarm.ca
Available at: the farmgate

Shoestring Ranch, Acme
antibiotic & hormone-free Angus beef
Ian, Carman & Ty Murray
403-546-0022
www.shoestringranch.ca
Available at: the farmgate; Bearspaw Farmers’ Market

Spragg’s Meat Shop, Rosemary
free-range antibiotic and growth hormone free pork and pork products, natural beef and free run antibiotic free chickens
Bonnie & Greg Spragg
403-378-3800
email: gbspragg@eidnet.org
Available at: Rosemary shop; Second to None Meats; Calgary Farmers’ Market; Grassroots Northland Farmers’ Market; Kingsland Farmers’ Market; Millarville Farmers’ Market; Brooks Farmers’ Market; Airdrie Farmer’s Market; Chestermere Farmers’ Market; Bearspaw Farmers’ Market; Vauxhaul Co-op
Available on the menu at: Char|Cut Roast House; District; Dairy Lane

Spruceview Family Farms Co-operative, Spruceview
hormone- and antibiotic- free natural meat CSA
Russell & Anita Wolf, Wolf Farm; Troy & Chrissy Conway, Conway Farm; Robin & Christie Severtson
403-746-3622 (Anita Wolf)
www.spruceviewfamilyfarm.ca
Available at: online ordering for CSA subscribers

Sunshine Organic Farm, Warburg
certified organic pastured Berkshire pork and grass-finished Angus beef, pastured poultry, eggs, house-made bacon, sausage, hams
Ed & Sherry Horvath
780-848-2288
www.sunshineorganicfarm.com
Available at: the farmgate; Edmonton Downtown Farmers’ Market

Sun to Earth Farm, Castor
natural grass finished Dexter & Galloway beef, lamb, pork and pastured chicken
Richard Griebel & Kathy Charpentier
403-882-3935
email: grebe6@telus.net
Available at: the farmgate by appointment

Sunworks Farm, Camrose
certified organic chickens, turkey, lamb, bison, pork, & beef, gluten-free sausages
Ron & Sheila Hamilton
1-877-393-3133
www.sunworksfarm.com
Available at: Calgary Farmers’ Market; Blush Lane Organic Market; Old Strathcona Farmers’ Market, Edmonton; St. Albert Farmers’ Market; Sunnyside Market
Available on the menu at: River Café; Café Leva, Edmonton; Avenue Diner; Blink

TLC Farm Katahdins, Sundre
naturally raised Katahdin lamb
Tracy & Carl Hooch-Antink
403-638-3173
www.tlcfarm.ca
Available at: the farmgate; Bearspaw Farmers’ Market

Trails End Ranch, Nanton
natural grass-fed dry-aged beef
Linda Loree & Rachel Herbert
403-646-3257
www.trailsendbeef.caom
Available at: the farmgate by appointment

Valbella Meats, Canmore
smokehouse & processors of Alberta beef, pork, chicken & game
Walter & Lonnie von Rotz
403-678-9989
www.valbellagourmetfoods.com
Available at: the store; all Sunterra locations; Jackson’s Deli; Janice Beaton Fine Cheese; The Cookbook Co. Cooks; many others

Valta Bison Farms, Valhalla Centre
Peace Country naturally raised bison & other local products at their 2 Calgary stores
Darlene & Gil Hegel
403-237-9667 Ramsay
403-240-7455 Calgary Farmers’’ Market Store until November 2010
www.valtabison.com
Available at: their locations in Ramsay and, Calgary Farmers’ Market; Hillhurst Sunnyside Farmers’ Market
Available on the menu: Crystal Mountain Lodge

Wapiti Ways, Calgary
elk, sausage, steaks, roasts, elk-based entrees
Craig Armstrong
1-888-927-4849
www.wapitiways.com
Available at: The Calgary Farmers’ Market Forage Farm to Fork Foods to Go
Available on the menu at: Infuse Catering; River Café

fish

Cunningham’s Scotch Cold Smoking, Pincher Creek
cold smoked rainbow trout, candied trout, smoked trout pâté
Joe Cunningham
403- 627-6594
www.cunninghamscoldsmoking.com
Available at: The Cookbook Co. Cooks; Janice Beaton Fine Cheese
Available on the menu at: River Café; Big Fish; A Ladybug Patisserie; Infuse Catering & Forage Farm to Fork Foods to Go; Bison Bistro & Lounge, Banff; Sage Bistro, Canmore; Q Haute

poultry

Country Lane Farms Ltd., Calgary
antibiotic-free chickens
Jerry & Nancy Kamphuis
403-934-2755
www.countrylanefarms.com
Available at: order online for monthly delivery to Calgary, Canmore & Red Deer
Available on the menu at: Calgary Stampede

Grazin’ Acres, Two Hills
organic poultry & natural lamb
John & Helene De Boer
1-888-657-2001
no website
Available at: Calgary Farmers’ Market

Noble Duck Farms, Nobleford
hormone-free & antibiotic-free Peking ducks
Gerwin Van Deuveren
403-315-9510
no website
Available at: the farmgate
Available on the menu at: Muse Restaurant; River Café; Rouge; The Banffshire Club, Fairmont Banff Springs Hotel, Banff; Open Range; Teatro; St. Germain

Sunworks Farm, Camrose
certified organic chickens, turkey, lamb, bison, pork, & beef, gluten-free sausages
Ron & Sheila Hamilton
1-877-393-3133
www.sunworksfarm.com
Available at: Calgary Farmers’ Market; Blush Lane Organic Market; Old Strathcona Farmers’ Market, Edmonton; St. Albert Farmers’ Market; Sunnyside Market
Available on the menu at: River Café; Café Leva, Edmonton; Avenue Diner; Blink

Winter’s Turkeys, Dalemead
certified organic & free-range turkeys
Corinne Dahm & Darrel Winter
403-936-5586
www.wintersturkeys.ca
Available at: the farmgate; Forage Farm to Fork Foods to Go; Meez; Amaranth Whole Foods Market; Bon Ton Meat Market; Community Natural Foods; Horizon Meats; Rocky’s Sausage Haus; Master Meats; Sunnyside Market; Valta Bison Farms, The Butcher Shoppe, Airdrie; many more
Available on the menu at: C ilantro; Char|Cut Roast House; Phil & Sebastian Coffee Co., Marda Loop; Café Jojo, Okotoks; Café Divine, Okotoks; Delta Lodge at Kananaskis

dairy
Bar-Ewe Dairy
AB Manchego
Tony *& Ditta Liefting
Box 735
Picture, Butte, AB
T0K 1V0
phone: 403.732.5099

Bles-Wold Dairy & Bles-Wold Yoghurt, Lacombe
Sour cream, yoghurt
Tinie Eilers & Hennie Bos
403-782-3322
www.bles-wold.com
Available at: Blush Lane Organic Market; Community Natural Foods; Sunterra Market; Calgary Co-op; Planet Organic; Sobey, Edmonton & Okotoks; Sobey’s, Calgary; Urban Bean
Available on the menu at: Delta Hotel, Banff; Robinson’s, Jasper; Juniper Hotel & Bistro, Banff

Fairwinds Farm, Fort Macleod
certified organic goat’s milk, yoghurt & cheeses
Ben & Anita Oudshoorn
403-553-0127
www.fairwindsfarm.ca
email: fairwindsfarm@telus.net
Available at: the farmgate;, Planet Organic;, Amaranth Whole Foods Market;, Community Natural Foods;, SPUD;, Sunnyside Market;, Sunterra Market;, Save- On Foods, Lethbridge & Red Deer; Olds Co-op; Spruce Grove IGA; Italian Centre, Edmonton; Homegrown Foods, Spruce Grove; Canmore Nutter’s Bulk & Natural Foods; Sbey’s, Okotoks;, Blush Lane Organics; Highwood Natural Food, High River; The Cookbook Co. Cooks
Available on the menu at: River Café; Miro, Lethbridge; 360, Lethbridge, plus others

Old West Ranch Ltd., Mountain View
mozzarella di bufala (water buffalo mozzarella cheese)
James Meservy
403- 634-7233
Available at: Forage Farm to Fork Foods to Go; Janice Beaton Fine Cheese
Available on the menu at: River Café; Rouge

Sylvan Star Cheese, Red Deer
award-winning gouda cheese, butter, gruyere, aged cheddar
Jan & Janny Schalkwijk
403-340-1560
www.sylvanstar.ca
Available at: the farmgate; Calgary Farmers’ Market; Janice Beaton Fine Cheese; The Cookbook Co. Cooks; Say Cheese Fromagerie; Bison Restaurant & Lounge, Banff

Vital Green Farms, Picture Butte
certified organic 52% heavy cream, milk, cheese, yoghurt, buttermilk, butter, sour cream, gouda
Joe & Caroline Mans
403-824-3072
no website
Available at: Blush Lane Organic Market; Amaranth Whole Foods Market; Community Natural Foods; Planet Organic; Sunnyside Market; Janice Beaton Fine Cheese; Eat Local First (www.eatlocalfirst.com), Edmonton
Available on the menu at: Infuse Catering & Farm to Fork Foods to Go; Red Tree; River Café; Calgary Petroleum Club

grains

Ehnes Organic Seed Cleaning Ltd., Etzikom
certified organic “Faith” Red Fife wheat flour
Bernie & Brian Ehnes
403-666-2047
www.ehnesorganic.com
Available at: the farmgate and order online

Grainworks Inc. – The Organic Grain Co., Vulcan
certified organic grains, peas & beans, mixes
Dwayne & Doreen Smith
1-800-563-3756
www.grainworks.com
Available at: Community Natural Foods; Amaranth Whole Foods; Nutter’s Bulk & Natural Foods; Bowness Health Foods; Planet Organic; Lakeview Bakery; Prairie Mill Bread Co.; Urban Bake; many other bakeries
Available on the menu at: Rouge; Blue Plate Diner, Edmonton; Jack’s Grill, Edmonton; Muse; Quarry Bistro, Canmore; River Café; Rush; Sage Bistro, Canmore

Heritage Harvest, Strathmore
stone-ground flour, mill, Red Fife wheat and heritage grains; conventional grains (Prairie Gold label)
Henry Winnicki, Mark Gibeau, Ray LeFebvre
403-934-3457 Mark Gibeau; 403-934-5809, Ray LeFebvre
no website
Available at: the farmgate by appointment

Highwood Crossing Foods Ltd. & Highwood Crossing Farm Ltd. ,Aldersyde
certified organic cold-pressed flax & canola oils, whole grains, flours & baking mixes, hot cereals, granola
Tony & Penny Marshall
403-652-1910
www.highwoodcrossing.com
Available at: Cookbook Co. Cooks; Forage Field to Fork Foods to Go; Community Natural Foods; Amaranth Whole Foods Market; Sunterra Market; Calgary Co-op; Canada Safeway; Sunnyside Market; Sobey’s; Lakeview Bakery; SPUD; plus others
Available on the menu at: Rouge; River Café; Palliser Hotel; Juniper Hotel & Bistro, Banff; Delta Calgary Airport; Calgary Hyatt Hotel; Infuse Catering & Forage Farm to Fork Foods to Go; plus others

Sun Prairie Organic Mills, Nanton
certified organic stone ground whole wheat and dark rye flour
Neall Coulson
403-646-5752
sunprairiemills@telus.net
Available at: at the mill; Calgary Co-op; Community Natural Foods; Okotoks Natural Foods

staples

Brassica Mustard, Calgary
prairie-flavoured mustards
Desmond Johnston & Karen Davis
403-277-3301
www.brassicamustard.com
Available at: Cookbook Co. Cooks; Sunterra Market; Community Natural Foods; Janice Beaton Fine Cheese; Sylvan Star Cheese, Sylvan Lake; Valbella Meats, Canmore; plus others

Chinook Honey Company, Okotoks
honey & honey products
Cherie & Art Andrews
403-995-0830
www.chinookhoney.com
Available at: the farmgate; Millarville Farmers’ Market; Hillhurst Sunnyside Farmers’ Market
Available on the menu at: Nectar Desserts; Cafe Divine, Okotoks; Blink

Vermi composting

We would like to keep in contact
we sell indoor compost worms ,and worm castings we do seminars to teach people the benefits of raising worms wee our web site Pat and Mark Worms @ Work www.wormsatwork.com ph. 403-730-3405


beverages

Chinook Arch Meadery, Okotoks
Alberta’s first mead (honey-based wine)
Cherie & Art Andrews
403-995-0830
www.chinookhoney.com
Available at: the farmgate; Millarville Farmers’ Market; Hillhurst Sunnyside Farmers’ Market

En Santé Organic Winery & Meadery, Brosseau
certified organic fruit-berry wines and mead
Elizabeth, Xina & Tonia Chrapko
780-657-2275
www.ensantewinery.com
Available at: the farm gate; many Alberta approved farmers’ markets; Alberta liquor stores

Fieldstone Fruit Wines, Strathmore
award-winning fruit-berry wines
Elaine & Marvin Gill & Lorraine & Glen Ellingson
403-934-2749
www.fieldstonefruitwines.com
Available at: the farmgate; Calgary Farmers’ Market; Bearspaw Farmers’ Market; Grassroots Northland Farmers’ Market; Kingsland Farmers’ Market; Sylvan Lake Farmers’ Market; Lethbridge Farmers’ Market; Brooks Farmers’ Market

Zora’s Lemonade Ltd., Calgary
certified organic lemonade concentrate
Liz Pedersen
403-246-2046
no website
Available at: Cookbook Co. Cooks; Sunterra Market; Mountain Mercato, Canmore; farmers’ markets around Calgary


Blue Mountain Biodynamic Farms, Carstairs
CSA, biodynamically raised certified-organic herbs, greens, vegetables, eggs, goats, house-milled flours and grains, frozen pork
Kris Vester & Tamara Brunt
403-337-3321
http://members.shaw.ca/bluemtnbio-dynamics/
Available at: SPUD, Sunnyside Market, Hillhurst Sunnyside Farmers’ Market, Farm Fresh Organics Home Delivery Ltd.
Available on the menu at: River Café

Buckler Farm, Bottrell
pesticide-free fruit, berries, vegetables, CSA
Charlie Buckler
403-804-7315
www.bucklerfarm.ca
Available at: the farmgate, Twisted Basil, Cochrane

Eagle Creek Farm – Bowden SunMaze, Bowden
flowers, heritage potatoes, garlic, vegetable CSA
John Mills, Terra Madre youth grower
403-224-3995
www.sunmaze.ca, www.eaglecreekfarms.ca
Available at: the farmgate, CSA subscription, Innisfail Growers booth at The Calgary Farmers’’ Market, Grassroots Northland Farmers’’ Market, Millarville Farmers’’ Market & other markets in season

Eat Food For Life Canada (Terra Caritatis Patris Farm), Clandonald
cooperative of small family farms, meat-based CSA “The Meats Market”, dry aged grass fed beef, soy-free turkey and chicken, lamb, certified organic pork, mentorship for emerging family farms
Tim & Maighread Axe
780-853-6046
www.eatfoodforlife.ca
Available at: order online, pick up and delivery to Edmonton, Calgary delivery soon to come

Heritage Market Gardens, Vulcan
CSA, heirloom tomatoes, berries, herbs, vegetables grown without pesticides
Jim & Donna Graff
403-485-2998
no website
Available: the farmgate by appointment, central weekly delivery to subscribers

New Oxley Ranch, Claresholm
natural garlic & CSA pastured poultry raised without antibiotics
Jackie Chalmers
403-625-5270
www. under construction
email: Jackie_chalmers@hotmail.com
Available at: the farmgate by appointment and at Paradise Hill Farm, Nanton

Oxyoke Farms, Linden
Natural meats; vegetables to CSA subscribers
Robby & Phyllis Fyn
403-546-0110
no website
Available at: the farmgate; vegetables to CSA subscribers

Thompson Small Farm, Carbon
CSA biodynamic vegetables raised with minimal carbon footprint (horse-powered)
Jon Wright & Andrea Thompson
403-572-3032
www.thompsonsmallfarm.ca
Available at: weekly pickup at Hillhurst Sunnyside Farmers’’ Market to CSA subscribers
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
In briefly looking at the source text, it doesn't appear to be evenly formatted to begin with. I suspect the amount of time required to get it 'scrubbed' so that you even could do something automatically you will have spent about as much time as just manually doing it.

Perhaps some of the other brilliant users on this site will see something I don't.
 
Upvote 0

Forum statistics

Threads
1,214,971
Messages
6,122,525
Members
449,088
Latest member
RandomExceller01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top