Hi Rob-ga,
I think I'll take on this question because of the challenge of
explaining the solution via text on the web.
Here's what I typed into the cells to parse the data into a row :
Cell Formula
B10 =A15
D10 =A10
E10 =LEFT($A11,C11-1)
F10 =IF(ISERROR(D11),IF(ISERROR(C11),"",RIGHT($A11,LEN($A11)-C11-1)),MID($A11,C11+2,D11-C11-2))
G10 =IF(ISERROR(E11),IF(ISERROR(D11),"",RIGHT($A11,LEN($A11)-D11-1)),MID($A11,D11+2,E11-D11-2))
H10 =IF(ISERROR(F11),IF(ISERROR(E11),"",RIGHT($A11,LEN($A11)-E11-1)),MID($A11,E11+2,F11-E11-2))
I10 =A12
J10 =A13
K10 =A14
L10 =IF(ISBLANK(A16),"",A16)
M10 =IF(ISBLANK(A17),"",A17)
C11 =SEARCH(",",$A11)
D11 =SEARCH(",",$A11,C11+1)
E11 =SEARCH(",",$A11,D11+1)
F11 =SEARCH(",",$A11,E11+1)
I did this for the first record, and then cut and pasted the area
B10:M19 to B20:M1819.
If you then copy the area B10:M1819 you can overwrite the formulae
with their values by going to Edit, Paste Special, Values, OK.
You can then sort the area B10:M1800 by column M and delete the
remaining rows.
The results I got are :
HELEN MORRIS Eastwell Manor Boughton Lees Ashford Kent TN25 4HR
01233 213000 01233 635530 eastwell@btinternet.com
michael denton Hartwell House Oxford Road Nr.
Aylesbury Buckinghamshire HP17 8NL 01296 747444 01296 747450 0
david dowden Bishopstrow House Warminster Wiltshire BA129HH 01985
212312 01985 216769 enquiries@bishopstrow.co.uk
kristina gray/alex thompson Hanover International Conference &
training Centre Chewton Place Chewton Road Keynsham Bristol BS31 2SX
0117 986 3105 0117 986 5948 conferenceoffice@chewton–place.co.uk
MICHELLE LEEKS Wivenhoe House Wivenhoe
Park Colchester Essex CO43SQ 01206 863666 01206
868532 wivsales@essex.ac.uk
SUE WILLET The Norfolk Royale Richmond Hill Bournemouth Dorset BH2
6EN 01202 551521 01202 299729 norfolkroyale@englishrosehotels.co.uk
jane OR peter wragg Widbrook Grange Trowbridge
Road Bradford-on-Avon Wiltshire BA15 1UH 01225 864750/863173 01225
862890 stay@widbrookgrange.com
HELEN NORRIS Burford Bridge Hotel Mickleham At The Foot of Box
Hill Dorking Surrey RH5 6BX 0870 400 8283 01306 880 386
gm1071@forte-hotels.com
Allan Heard Cannizaro House West Side Wimbledon Common London
SW194UE 0870 333 9124 0870 333 9224
MandE.cannizarohouse@thistle.co.uk
Samantha Maeer Covent Garden Hotel 10 Monmouth
Street London WC2H9HB 020 7806 1000 020 7806 1100 covent@firmdale.com
andrea humphreys/mary lucioni Bailiffscourt Hotel Climping West
Sussex BN17 5RW 01903 723511 01903 718987
bailiffscourt@hshotels.co.uk
emma neve Epsom Downs Racecourse Queen’s Stand The Racecourse Epsom
Downs Surrey KT18 5LQ 01372 726311 01372 748253 epsom@rht.net
Pat Barksby Ghyll Manor Country Hotel High Street Rusper near
Horsham West Sussex RH124PX 01293 871571 01293 871419
jon.fisher@csma.uk.com
TINA O’SHAUGHNESSY Gorse Hill Executive Centre Hook Heath
Road Woking Surrey GU220QH 01483 747444 01483 747454
gorsehill@initialstyle.co.uk
Tracy Garner Hanbury Manor Ware Hertfordshire SG120SD 01920
487722 01920 487692
conferenceandevents.hanburymanor@marriotthotels.co.uk
Tracey Davies Lords Of The Manor Hotel Upper Slaughter Nr.
Bourton-On-The-Water Gloucestershire GL542JD 01451 820243 01451
820696 lordsofthemanor@btinternet.com
HEATHER HEWETT The Cheltenham Park Hotel Charlton
Kings Cheltenham Gloucestershire GL53 8EA 01242 222021 01242
254880 cheltenhampark@paramount-hotels.co.uk
THE CONFERENCE SALES TEAM Harrington Hall 5-25 Harrington
Gardens London SW7 4JW 020 7396 9696 020 7396 9090
harringtonsales@compuserve.com
ALYSON KENNEDY Hartsfield Manor Sandy Lane Betchworth Surrey RH3
7AA 01737 842821 01737 845129 akennedy@initialstyle.co.uk
SAMANTHA DORRELL Kingsway Hall Great Queen Street Covent
Garden London WC2B 5BX 020 7309 0909 020 7309 9129
kingswayhall@compuserve.com
NICKY HOSIE Oatlands Park Hotel Oatlands Drive Weybridge Surrey
KT139HB 01932 847242 01932 842252 info@oatlandsparkhotel.com
yvette dunn Sir Christopher Wren's House Hotel 56 Thames
Street Windsor Berkshire SL4 1QW 01753 861354 01753 442490 0
Caroline Turner Taplow House Hotel Berry Hill Taplow Nr
Maidenhead Buckinghamshire SL60DA 01628 670056 01628
773625 taplow@wrensgroup.com
CARLA SVEHLIK The PowderMills Powdermill Lane Battle East Sussex
TN33 0SP 01424 775511 01424 774540 powdc@aol.com
Margaret Kavanagh The Academy, The Bloomsbury Town House 21 Gower
Street London WC1E6HG 020 7631 4115 020 7636 3442
res_academy@etontownhouse.com
natasha ketteridge The Castle Hotel High Street Windsor Berkshire
SL41LJ 0870 400 8300 01753 830244 castle@heritage–hotels.co.uk
katherine skalinski Fawsley Hall Near Daventry Northamptonshire
NN11 3BA 01327 892000 01327 892001/2 info@fawsleyhall.com
Clare Snow Highgate House Creaton Northamptonshire NN68NN 01604
505505 01604 505656 highgate@sundialgroup.com
Emma Nurse The Compleat Angler Marlow Bridge Marlow Buckinghamshire
SL71RG 0870 400 8100 01628 486 388
heritagehotels_marlow.compleat_angler@forte-hotels.com
Conference Office The Grange-City 8-10 Coopers Row London EC3
2BD 020 7863 3700 020 7863 3701 city@grangehotels.co.uk
LUCY HOLMES The Dairy At Waddesdon Manor Queen
Street Waddesdon Buckinghamshire HP18 0JW 01296 653241 01296
653208 TWMLJH@smtp.ntrust.org.uk
conference office The Grange-Fitzrovia 20-28 Bolsover
Street London W15NB 020 7467 7000 020 7636
5085 fitzrovia@grangehotels.co.uk
conference office The Grange-Holborn 50-60 Southampton
Row London WC1 4AR 020 7242 1800 020 7404
1641 holborn@grangehotels.co.uk
conference office The Grange-Bracknell Charles
Square Bracknell Berkshire RG121DF 01344 474000 01344
474125 bracknell@grangehotels.co.uk
DEBORAH AZAGURY The Milestone Hotel & Apartments 1 Kensington
Court London W85DL 020 7917 1000 020 7917 1010
meetms@rchmail.com
Jane Wainright The Randolph Beaumont Street Oxford OX12LN 0870
400 8200 01865 791678 events.randolph@macdonald–hotels.co.uk
Deborah Smallman The Spread Eagle Hotel & Health Spa South
Street Midhurst West Sussex GU299NH 01730 816911 01730 815668
spreadeagle@hshotels.co.uk
SADIELUDLOW Theobalds Park Bulls Cross Ride Cheshunt Hertfordshire
EN7 5HW 01992 633375 01992 634212 sludlow@initialstyle.co.uk
AMY RIDER Threadneedles 5 Threadneedle Street London EC2R8BD 020
7657 8080 020 7289 4878 res_threadneedles@etontownhouse.com
Stephanie Lombard Westbury Hotel Bond Street Mayfair London W1S 2YF
020 7629 7755 020 7495 1163 westburyhotel@compuserve.com
Nicola Trigg/Rebecca Price Barnett Hill Wonersh Near
Guildford Surrey GU50RF 01483 893361 01483 892836
barnett@sundialgroup.com
tracey lethaby Woodlands Park Hotel Woodlands Lane Stoke
D’abernon Cobham Surrey KT11 3QB 01372 843933 01372 842704
events-woodlands@arcadianhotels.co.uk
jeannie lea Alveston Manor Clopton
Bridge Stratford-Upon-Avon Warwickshire CV377HP 0870 400 8181 01789
414095 heritagehotels_stratford_upon_avon.alveston_manor@forte-hotels.com
SALES OFFICE The Olde Barn Hotel Toll Bar Road Marston Lincolnshire
NG322HT 01400 250909 01400 250130 sales@olde–barn–hotel.co.uk
Nick Quinn Barnsdale Lodge The Avenue Rutland Water Nr
Oakham Rutland LE158AH 01572 724678 01572 724961
barnsdale.lodge@btconnect.com
WALTER FALLOn Charingworth Manor Nr Chipping Campden Gloucestershire
GL55 6NS 01386 593555 01386 593353
charingworthmanor@englishrosehotels.co.uk
BETHANY RYAN Coombe Abbey Brinklow Road Binley Coventry Warwickshire
CV3 2AB 024 7645 0450 024 7663 5101 0
Debbie Linney Ettington
Park Alderminster Stratford-upon-Avon Warwickshire CV37 8BU 01789
450123 01789 450876 ettington@arcadianhotels.co.uk
elizabeth stevenson Charles House 18b Charles Street Mayfair London
W1J5DU 020 7667 6611 020 7665 5588 info@argyllbusinesscentres.com
Bridget Glazebrook Madeley Court Madeley Telford Shropshire TF7
5DW 01952 680068 01952 684275 admin@gb068.u–net.com
JENNIFER KETTELL New Hall Walmley Road Royal Sutton Coldfield West
Midlands B761QX 0121 378 2442 0121 378
4637 mande.newhall@thistle.co.uk
Ann Finucane Swinfen Hall Hotel Swinfen Nr
Lichfield Staffordshire WS149RE 01543 481494 01543
480341 swinfen.hall@virgin.net
paul quinn Fifehead Manor Middle Wallop Stockbridge Hampshire SO20
8EG 01264 781565 01264 781400 fifeheadmanor@ukonline.co.uk
nicola round The Elms Abberley Worcester Worcestershire
WR66AT 01299 896666 01299 896804 elmshotel@ukonline.co.uk
TRACEY LOPEZ-LING The Mount Conference Centre Mount Road Tettenhall
Wood West Midlands WV68HL 01902 752055 01902
745263 tling@firstvenues.com
Louise Barrington Weston Manor Weston-on-the-Green Oxford OX6 8QL
01869 350621 01869 350901 reception@westonmanor.co.uk
becky wright Wood Norton Hall Wood Norton Evesham Worcestershire
WR11 4YB 01386 420007 01386 420679 woodnortonhall.info@bbc.co.uk
Joanne Macaulay Woodside Glasshouse Lane Kenilworth Warwickshire
CV8 2AL 01926 852217 01926 859550 woodside@sundialgroup.com
Rachael Willis/Margaret Deakin Wroxall Court Wroxall Abbey
Estate Birmingham Road Wroxall Warwickshire CV357NB 01926 484470 01926
485206 info@wroxallestate.com
01491 570528 0 #VALUE! Marlow Road, Henley-on-Thames, Oxon RG9
2HT 01491 570500 Roger Best enquiries@phylliscourt.co.uk
MICHAEL MORGAN Llansantffraed Court Hotel Llanvihangel
Gobion Abergavenny monmouthshire NP7 9BA 01873 840678 01873 840674
conferences@llch.co.uk hhtp://www.llch.co.uk
sales Chewton Glen New Milton Hampshire BH256QS 01425 275341
01425 272310 sales@chewtonglen.com http://chewtonglen.com
Marilyn Watkinson Down Hall Country House Hotel Hatfield Heath Nr
Bishop's Stortford Hertfordshire CM22 7AS 01279 731441 01279
730416 reservations@downhall.demon.co.uk http://downhall.demon.co.uk
Jerry Stephenson A Day In The Country Upper Aynho
Grounds Aynho Banbury Oxon OX173AY 01869 810823 01869
810892 jerry@adayinthecountry.co.uk http://www.adayinthecountry.co.uk
CRAIG DAVIS Addington Palace Gravel Hill Addington
Village Croydon Surrey CR05BB 020 8662 5000 020 8662 5001
0 http://www.addington-palace.co.uk
sally moon Alexander House Hotel Turner’s Hill West Sussex RH10
4QD 01342 714914 01342 717328 info@alexanderhouse.co.uk
http://www.alexanderhouse.co.uk
emma pearson Amberley Castle Amberley Nr Arundel West Sussex BN18
9ND 01798 831992 01798 831998 info@amberleycastle.co.uk
http://www.amberleycastle.co.uk
DAWN SALE The Ardencote Manor Hotel & Country Club Lye Green
Road Claverdon Nr Warwick Warks CV358LS 01926 843111 01926 842646
hotel@ardencote.com http://www.ardencote.com
amanda humble Ashdown Park Hotel Wych Cross Nr Forest Row East
Sussex RH18 5JR 01342 824988 01342 826206 sales@ashdownpark.com
http://www.ashdownpark.com
CAROL JOHNSTON Ashridge Berkhamsted Hertfordshire HP4 1NS 01442
841027 01442 841010 carol.johnston@ashridge.org.uk
http://www.ashridge.com
NICOLA BUTLER Athenaeum Hotel and Apartments 116 Piccadilly London
W1J7BJ 020 7499 3464 020 7493
1860 info@athenaeumhotel.com http://www.athenaeumhotel.com
SARAH BULLEN / DIANA HOGG Avington Park Avington Near
Winchester Hampshire SO211DD 01962 779260 01962
779864 sarah@avingtonpark.co.uk http://www.avingtonpark.co.uk
Stuart Elmes The Berners Hotel Berners Street London W1A 3BE 020
7666 2000 020 7666 2001 berners@berners.co.uk
http://www.berners.co.uk
Joanne Reeves Billesley Manor Billesley Alcester nr
Stratford-upon-Avon Warwick B496NF 01789 279955 01789 764145
bookings@billesleymanor.co.uk http://www.billesleymanor.co.uk
Matthew Johnstone Bodysgallen Hall Llandudno North Wales
LL301RS 01492 584466 01492 582519 info@bodysgallen.com
http://www.bodysgallen.com
Emma Boynton Burleigh Court JCT23 M1 Ashby Road Loughborough LE11
3TD 01509 211515 01509 211569 info@burleigh–court.co.uk
http://www.burleigh-court.co.uk
Erica Waldron Calcot Manor Near Tetbury Gloucestershire
GL88YJ 01666 890391 01666 890394 reception@calcotmanor.co.uk
http://www.calcotmanor.com
MANDY OR JEANETTE Careys Manor Hotel Brockenhurst New
Forest Hampshire SO42 7RH 01590 623551 01590 622799
info@careysmanor.com http://www.careysmanor.com
Andrea Fowkes Castle Ashby Castle Ashby Northampton NN71LQ 01604
696696 01604 696516 admin@castleashby.co.uk
http://www.castleashby.co.uk
EMMALENE TURNER Champneys Health Resort Chesham
Road Wigginton Tring Herts HP236HY 01442 291296 01442 291292
emmalene.turner@champneys.co.uk http://www.champneys.co.uk
Sibel Capa Charlotte St. Hotel 15 Charlotte
Street London W1P1HB 020 7806 2000 020 7806
2002 charlotte@firmdale.com http://www.charlottestreethotel.com
The Reservations Team The Node Conference Centre Hitchin
Road Codicote Nr. Hitchin Hertfordshire SG48TL 01438 820361 01438
821347 node@chartridge.co.uk http://www.chartridge.co.uk
Colin Parcell/Karen Jeffs The Chase Hotel Gloucester
Road Ross-on-Wye Herefordshire HR9 5LH 01989 763161 01989 768330
info@chasehotel.co.uk http://www.chasehotel.co.uk
PHILIP GATES Chatsworth Stables Chatsworth Bakewell Derbyshire
DE45 1PP 01246 565377 01246 565381
info@chatsworthcatering.com http://www.chatsworth-house.co.uk
Simon Hunter Chelsea Village Stamford Bridge Fulham
Road London SW61HS 020 7565 1900 020 7915
1914 conference@chelseavillage.com http://www.chelseavillage.com
Christine Griffiths Chilworth Manor Chilworth Southampton Hampshire
SO167PT 023 8076 7333 023 8076 6392 general@chilworth-manor.co.uk
http://www.chilworth-manor.co.uk
AMANDA OLVER The Conference Centre - Church House Dean’s
Yard Westminster London SW1P 3NZ 020 7390 1590 020 7390 1591
sales@churchhouseconf.co.uk http://www.churchhouseconf.co.uk
HEATHER BROWN Combe Grove Manor Hotel & Country Club Brassknocker
Hill Monkton Combe Bath Avon BA2 7HS 01225 834644 01225 834961
info@combegrovemanor.com http://www.combegrovemanor.com
claire Weiss Coppid Beech Hotel John Nike
Way Bracknell Berkshire RG128TF 01344 303333 01344
301200 sales@coppid–beech–hotel.co.uk http://www.coppidbeach.com
Giles Hine Corse Lawn House Hotel Corse Lawn Nr
Tewkesbury Gloucestershire GL194LZ 01452 780771 01452 780840
hotel@corselawnhouse.u-net.com http://www.corselawnhouse.u-net.com
The Conference Co-ordinator The Bear of Rodborough Hotel Rodborough
Common Stroud Gloucestershire GL55DE 01453 878522 01453 872523
bookings@cotswold-inns-hotels.co.uk
http://www.cotswold-inns-hotels.co.uk
CERI POWELL Cumberwell Park Bradford-on-Avon Wiltshire BA1 52PQ
01225 863322 01225 868160 cerip@cumberwellpark.com
http://www.cumberwellpark.co.uk
Carol Shearman Danesfield House Hotel & Spa Henley
Road Marlow-on-Thames Buckinghamshire SL72EY 01628 891010 01628
890408 events@danesfieldhouse.co.uk http://www.danesfieldhouse.co.uk
RICHARD HAZELWOOD Dartington Hall Conference
Centre Dartington Totnes Devon TQ9 6EL 01803 847147 01803 847107
bookings@dartingtonhall.com http://www.dartingtinhall.com
Caroline Vidler Grand Harbour West Quay
Road Southampton Hampshire SO151AG 023 8063 3033 023 8063
3066 grandharbour@devere–hotels.com http://www.deveregrandharbour.co.uk
Joanne Stillwell Dolphin Square Hotel Chichester Street London
SW1V 3LX 020 7834 3800 020 7798 8735
reservations@dolphinsquarehotel.co.uk http://www.dolphinsquarehotel.co.uk
Gabrielle Gibbons Donnington Valley Hotel & Golf Course Old Oxford
Road Donnington Newbury Berkshire RG143AG 01635 551199 01635 551123
general@donningtonvalley.co.uk http://www.donningtonvalley.co.uk
Philippa Hughes The Dorchester Park Lane Mayfair London W1A2HJ 020
7629 8888 020 7317 6363 banqueting@dorchesterhotel.com
http://www.dorchesterhotel.com
Anne-Marie Daly Dunchurch Park Dunchurch Rugby Warwickshire
CV226QW 01788 810656 01788 814451 adaly@dunchurch.co.uk
http://www.dunchurch.co.uk
JOAN HARDMAN East Lodge Country House
Hotel Rowsley Matlock Derbyshire DE4 2EF 01629 734474 01629 733949
info@eastlodge.com http://www.eastlodge.com
GENNY SUTCLIFFE The Elvetham Hartley Wintney Basingstoke Hampshire
RG27 8AR 01252 844871 01252 844161 enq@elvetham-hall.co.uk
http://www.elvetham-hall.co.uk
Joanne Silverwood – Conference & Events Sales Manager Eynsham
Hall North Leigh Witney Oxfordshire OX296PN 01993 885200/227 01993
883986 conferenceoffice@eynsham-hall.co.uk http://www.eynsham-hall.co.uk
PETER BATE The Feathers Hotel Market
Street Woodstock Oxfordshire OX201SX 01993 812291 01993
813158 enquiries@feathers.co.uk http://www.feathers.co.uk
SALLY PARKINSON Five Lakes Hotel, Golf, Country Club & Spa Colchester
Road Tolleshunt Knights Maldon Essex CM98HX 01621 868888 01621
869696 enquiries@fivelakes.co.uk http://www.fivelakes.co.uk
Edward Walmsley The Gibbon Bridge Hotel Nr Chipping Forest of
Bowland Lancashire PR32TQ 01995 61456 01995
61277 conferencing@gibbon–bridge.co.uk http://www.gibbon-bridge.co.uk
Julia Condesa De Matzenau Gibson Hall 13 Bishopsgate London
EC2M4QB 020 7334 3983 020 7334 3981 sales@gibsonhall.co.uk
http://www.gibsonhall.co.uk
LINDSAY COOPER The Grand Hotel King Edward’s Parade Eastbourne East
Sussex BN21 4EQ 01323 412345 01323 412233
sales@grandeastbourne.com http://www.grandeastbourne.com
AMANDA dougans Great Fosters Stroude Road Egham Surrey TW20 9UR
01784 433822 01784 472455 amanda@greatfosters.co.uk
http://www.greatfosters.co.uk
DAWN KING Henley Management
College Greenlands Henley-on-Thames Oxfordshire RG93AU 01491 418810
01491 571635 dawnk@henleymc.ac.uk http://www.henleymc.ac.uk
PAULINE FRYATT Hever Castle Tudor Village Hever Nr. Edenbridge Kent
TN8 7NG 01732 861743 01732 867860 tudor@hevercastle.co.uk
http://www.hevercastle.co.uk
andrea gardner Hitchin Priory Hitchin Hertfordshire SG5 2DL
01462 420500 01462 422101 info@hitchinpriory.co.uk
http://www.hitchinpriory.co.uk
Louise Spicer Hoar Cross Hall Health Spa Resort Hoar Cross Nr.
Yoxall Staffordshire DE138QS 01283 575671 01283 575652
info@hoarcross.co.uk http://www.hoarcross.co.uk
Jenny Pinnegar Horsted Place Little Horsted Uckfield East
Sussex TN225TS 01825 750581 01825
750459 hotel@horstedplace.co.uk http://www.horstedplace.co.uk
ANDREW HUCKERBY Kitley House Hotel Kitley
Estate Yealmpton Plymouth Devon PL82NW 01752 881555 01752 881667
sales@kitleyhousehotel.com http://www.kitleyhousehotel.com
Events Office Knowsley Prescot Liverpool Merseyside L344AG 0151
489 4827 0151 480 5580 events@knowsley.com http://www.knowsley.com
PATSIE E A ENRIGHT Lainston House Sparsholt Winchester Hampshire
SO212LT 01962 863588 01962 776672 enquiries@lainstonhouse.com
http://www.lainstonhouse.com
Glen Murray Left Bank Village & Castle House Bridge
Street Hereford HR49DG 01432 349009 01432
268023 info@leftbank.co.uk http://www.leftbank.co.uk
sheila morrison LLangoed Hall Llyswen Brecon Powys Wales LD30YP 01874
754525 01874 754545 Llangoed_Hall_Co_Wales_UK@compuserve.com http://www.llangoedhall.com
JO SPARROW Longleat Warminster Wiltshire BA127NW 01985 844400 01985
844885 conferences@longleat.co.uk http://www.longleat.co.uk
SeanDavies Lower Slaughter Manor Lower
Slaughter Gloucestershire G152HP 01451 820456 01451 822150
lowsmanor@aol.com http://www.lowerslaughter.co.uk
mark littledale Lucknam Park Colerne Chippenham Wiltshire SN14 8AZ
01225 742777 01225 743536 banqueting@lucknampark.co.uk
http://www.lucknampark.co.uk
jane denly-smith Lythe Hill Hotel Petworth Road Haslemere Surrey
GU27 3BQ 01428 651251 01428 644131 lythe@lythehill.co.uk
http://www.lythehill.co.uk
MAUREEN WOOD Aston Business School Management Development
Centre Aston Triangle Birmingham B47ET 0121 359 3011 0121 359
2721 nbhosp@aston.ac.uk http://www.meetings.abs.aston.ac.uk
EMMA PETERS Nailcote Hall Nailcote Lane Berkswell Nr Coventry
Warwickshire CV7 7DE 024 7646 6174 024 7647 0720
info@nailcotehall.co.uk http://www.nailcotehall.co.uk
Virgina Childs Newick Park Newick Near Lewes East Sussex
BN84SB 01825 723633 01825 723969 bookings@newickpark.co.uk
http://www.newickpark.co.uk
Shelagh Reay/Suzanne Hodgson Park Farm Country
Hotel Hethersett Norwich Norfolk NR9 3DL 01603 810264 01603 812104
enq@parkfarm-hotel.co.uk http://www.parkfarm-hotel.co.uk
Sue Lester Park Hall Hotel Chorley Nr
Preston Lancashire PR75LP 01257 455000 01257
451838 conference@parkhall–hotel.co.uk http://www.parkhall-hotel.co.uk
PENELOPE TOMPSON The Pendley Manor Hotel Cow
Lane Tring Hertfordshire HP235QY 01442 891891 01442 828840
enquiries@pendley–manor.co.uk http://www.pendley-manor.co.uk
Sally J. Smith Ragley Hall Alcester Warwickshire B495NJ 01789
762090 01789 764791 info@ragleyhall.com http://www.ragleyhall.com
RICHARD VOWELL The Red Lion Hotel Henley-on-Thames Oxfordshire
RG9 2AR 01491 572161 01491 410039
reservations@redlionhenley.co.uk http://www.redlionhenley.co.uk
Teresa Duncan The Regency Park Hotel Bowling Green
Road Thatcham Berkshire RG183RP 01635 871555 01635
871571 info@regencyparkhotel.co.uk http://www.regencyparkhotel.co.uk
Wendy Gunn / Laura Dawson Risley Hall Country House Hotel Derby
Road Risley Derbyshire DE723SS 0115 939 9000 0115 939 7766
enquiries@risleyhallhotel.co.uk http://www.risleyhallhotel.co.uk
Wendy Gunn / Laura Dawson Risley Hall Country House Hotel Derby
Road Risley Derbyshire DE723SS 0115 939 9000 0115 939 7766
enquiries@risleyhallhotel.co.uk http://www.risleyhallhotel.co.uk
Events Manager The Roof Gardens 99 Kensington High
Street London W85ED 020 7937 7994 020 7938
2774 events@roofgardens.virgin.co.uk http://www.roofgardens.com
Lisa Wood The Rookery Peter’s Lane Cowcross Street London EC1M 6DS
020 7336 0931 020 7336 0932 reservations@rookery.co.uk
http://www.rookery.co.uk
karen norton Rowton Castle Rowton Castle Hotel Rowton Halfway
House Shrewsbury SY59EP 01743 884044 01743
884949 post@rowtoncastle.com http://www.rowtoncastle.com
PAUL COOKSON Royal Garden Hotel 2-24 Kensington High
Street Kensington London W8 4PT 020 7937 8000 020 7361 1991
anthonyhyde@royalgardenhotel.co.uk http://www.royalgardenhotel.co.uk
TESSA CONWAY-HOLLAND Sadler's Wells Roseberry
Avenue London EC1R4TN 020 7863 8065/2 020 7863
8199 events@sadlerswells.com http://www.sadlers-wells.com
Sally Pearce Salford Hall Hotel Abbots Salford Nr.
Evesham Worcestershire WR115UT 01386 871300 01386 871301
reception@salfordhall.co.uk http://www.salfordhall.co.uk
LYNN INGREY Sandown Park Portsmouth Road Esher Surrey KT109AJ 01372
464790 01372 465205 sandown.events@rht.net http://www.sandown.co.uk
Julie Wooliston Sopwell House Hotel, Country Club & Spa Cottonmill
Lane Sopwell St Albans Hertfordshire AL12HQ 01727 864477 01727
844741 enquiries@sopwellhouse.co.uk http://www.sopwellhouse.co.uk
BRENDA WOOD The Spa Hotel Mount Ephraim Royal Tunbridge Wells Kent
TN48XJ 01892 520331 01892 510575 info@spahotel.co.uk
http://www.spahotel.co.uk
Amanda Maskell/Georgina Welch/Liz Hodges Stapleford Park Hotel, Spa,
Golf and Sporting Estate Nr Melton Mowbray Leicestershire
LE142EF 01572 787 522 01572 787 651 amaskell@stapleford.co.uk
http://www.stapleford.co.uk
Joanne Scott Stoke Park Club Park Road Stoke Poges Buckinghamshire
SL2 4PG 01753 717171 01753 717181 info@stokeparkclub.com
http://www.stokeparkclub.com
Vicky Kimberley Stone Manor Hotel Stone Nr.
Kidderminster Worcestershire DY104PJ 01562 777555 01562 777834
enquiries@stonemanorhotel.co.uk http://www.stonemanorhotel.co.uk
Mike Smith Hanover International Conference & Training Centre
Sundridge Park Plaistow Lane Bromley Kent BR1 3TP 020 8313 3232
020 8313 7500 info@sundridgepark.com http://www.sunridgepark.com
Mike Smith Hanover International Conference & Training Centre
Sundridge Park Plaistow Lane Bromley Kent BR1 3TP 020 8313 3232
020 8313 7500 info@sundridgepark.com http://www.sunridgepark.com
julie podmore Belstead Brook Hotel Belstead Road Ipswich Suffolk
IP29HB 01473 684241 01473 681249
sales@belsteadbrook.co.uk http://www.swallowhotels.com/ipswich_index.htm
MALCOLM WATSON The Basil Street Hotel Knightsbridge London
SW31AH 020 7581 3311 020 7581 3693 banqueting@thebasil.com
http://www.thebasil.com
Amanda Wellfelt The Manor House Huxley Close Godalming Surrey GU7
2AS 01483 413021 01483 413036 0 http://www.themanor.co.uk
emma cale Tylney Hall Rotherwick Nr. Hook Hampshire RG27 9AZ
01256 764881 01256 760224 sales@tylneyhall.com
http://www.tylneyhall.com
CLAUDIA SCHUITEMAKER Victoria Park Plaza 239 Vauxhall Bridge
Road London SW1V1EQ 020 7769 9999 020 7769
9998 info@vpp-sw1.com http://www.vpp.sw1.com
Helen Litchfield Wadenhoe House Wadenhoe Nr. Oundle Peterborough
PE85SS 01832 720777 01832 720410 house@wadenhoe.com
http://www.wadenhoe.com
CAROLYN BAILEY Warren House Warren Road Kingston-upon-Thames Surrey
KT2 7HY 020 8547 1777 020 8547 1175 carolyn@warrenhouse.com
http://www.warrenhouse.com
Jim Brandon Central Hall Westminster Storey’s
Gate Westminster London SW1H9NH 020 7222 8010 020 7222
6883 events@c-h-w.co.uk http://www.wch.co.uk
The Sales Office Welcombe Hotel & Golf Course Warwick
Road Stratford-upon-Avon Warwickshire CV37ONR 01789 295252 01789
414666 sales@welcombe.co.uk http://www.welcombe.co.uk
Conference Dept West Lodge Park Cockfosters Road Hadley
Wood Barnet Hertfordshire EN4 0PY 020 8216 3900 020 8216 3937
info@westlodgepark.com http://www.westlodgepark.com
COLIN SWEENEY Weston Park Weston-under-Lizard Nr. Shifnal Shropshire
TF118LE 01952 852100 01952 850430 enquiries@weston-park.com
http://www.weston-park.com
Melissa Fell Whittlebury Hall Whittlebury Nr.
Towcester Northamptonshire NN12 8QH 01327 857857 01327 857867
sales@whittleburyhall.co.uk http://www.whittleburyhall.co.uk
IAN WILKINSON The Wind In The Willows Derbyshire
Level Glossop Derbyshire SK137PT 01457 868001 01457
853354 info@windinthewillows.co.uk http://www.windinthewilows.co.uk
Linda Selby Witley Park Lea Court Lea Coach Road Thursley Nr
Godalming GU8 6ND 01428 685611 01428 685139 Sales@witleypark.co.uk
http://www.witleypark.co.uk
THE EVENTS TEAM Woodbury Park Hotel Woodbury
Castle Woodbury Exeter Devon EX51JJ 01395 233382 01395 233384
events@woodburypark.co.uk http://www.woodburypark.co.uk
01235 862577 0 #VALUE! Milton Hill, Abingdon,
Oxfordshire OX136AF 01235 831474 Cherly
Cutts milton@initialstyle.co.uk
01491 415601 0 #VALUE! Mill Meadows, Henley-On-Thames,
Oxfordshire RG91BF 01491 415610 Sophie Horton museum@rrm.co.uk
020 7976 0697 0 #VALUE! One Great George Street, Westminster,
London SW1P 3AA 020 7665 2323 Victoria Rooke oggs@ice.org.uk
020 8399 7475 0 #VALUE! Raven's Ait Island, Portsmouth Road,
Surbiton, Surrey KT64HN 020 8339 6960 Ssteven Squires
ravensait@aol.com
020 7224 0900 0 #VALUE! 11 St Andrews Place, Regent’s Park,
London NW14LE 020 7935 1174 Angela
Bachtler sales@royalgardenhotel.co.uk
Quentin Creese Washbourne Court Hotel Lower Slaughter Gloucestershire
GL542HS 01451 822143 01451 821045 washbournecourt@msn.com Website
emma bratley kendal Ringwood Hall Hotel Ringwood
Road Brimington Chesterfield Derbyshire S431DQ 01246 280077 01246
472241 reception@ringwoodhall.fsnet.co.uk Website
THE EVENT OFFICE Brocket Hall Welwyn Hertfordshire AL87XG 01707
335241 01707 375166 events@brocket–hall.co.uk Website
CHARLES FIELDER/BECCY THORP Commonwealth Conference & Events
Centre Kensington High Street London W86NQ 020 7603 3412 020 7603
9634 info@commonwealth.org.uk Website
LINDA CUTHBERT/SUE NEWMAN Missenden Abbey Great
Missenden Buckinghamshire HP160BD 01494 866811 01494
866737 sales@missendenabbey.ltd.uk Website
EVENTS OFFICE Monkey Island Bray-on-Thames BerkShire SL6 2EE
01628 623400 01628 784732 ev.monkeyisland@btconnect.com Website
Clare Trayler Nutfield Priory Nutfield Redhill Surrey RH14EN 01737
824400 01737 823321 nutpriory@aol.com Website
01993 702002 0 #VALUE! Minster Lovell, Oxfordshire OX85RN 01993
774441 themill@initialstyle.co.uk Website
Sarah Jane Paramor The Angel Hotel North Street Midhurst West Sussex
GU299DN 01730 812421 01730 815928 angel@hshotel.co.uk Website
catrina sorel-cameron The Berystede Bagshot
Road Sunninghill Ascot Berkshire SL5 9JH 0870 400 8111 01344 872301
HeritageHotels_Ascot.Berystede@forte-hotels.com Website
ANDREA FEIN The Montague on the Gardens 15 Montague
Street Bloomsbury London WC1B 5BJ 020 7637 1001 020 7637 2516
meetmt@rchmail.com Website
fiona tipson/JAYNE BROWN The Glebe at Barford Church
Street Barford Warwickshire CV358BS 01926 624218 01926 624625
sales@glebehotel.co.uk Website
LYNN NIXON Williams F1 Grove Wantage Oxfordshire OX120DQ 01235
777836/777822 01235 777730 lynn.nixon@williamsf1.com Website
cherril-ann starmer Ockenden Manor Ockenden Lane Cuckfield West
Sussex RH17 5LD 01444 416111 01444 415549 ockenden@hshotels.co.uk
Website
With a bit of luck you can take this data, paste it into excel and
then use the text to columns function to separate it out into the
desired format and hence save yourself the hassle of following my
steps.
Let me know if that doesn't make sense - It's kind of difficult to
explain excel in an email format. I'd be happy to provide more of a
background into methodology if you are interested, but I figured you
were more interested in the results.
Regards
-Calebu2 |
