extracting a string from a cell

[cjsmith22]

is there any way to extract whatever string is in a particular cell in order to then compare that string with strings in cells in other ranges?

 

[stuartford]

can you give a little bit more detail about the task you want to perform


Stuart

 

[BBHRVS]

hi;
you can use several functions within macros or formulas:
mid(string,start, lengh) extracts as from "start" the number of character "length" from the cell.value (string)
or
trim (string) extracts of a string without the right/left blank spaces
or left(string, length) extracts the left part of a string for a certain number of characters(length)
or right(string,length same for right part)

to know how long is the string of a particular cell, use the function : len(string)
Hope this helps

 

[cjsmith22]

thanks for the response - what i need to do is quite complicated - or at least it is to me - i have two ranges (myfootballresults and myleaguetable) in a worksheet and what i need to do is update the leaguetable according to the results. so if, for example, the first result is chelsea 2 villa 1
i need to check whats in the first cell (in this case chelsea), check whether they won, drew or lost, then i need to match the cell (chelsea) with the same cell(chelsea) in the myleaguetable range, and then update the myleaguetable accordingly. that make any sense? cheers in advance

Copy of Table.xls
	A	B	C	D	E	F	G	H	I
13	24-Sep-05	Chelsea			2	AstonVilla			1
14	24-Sep-05	Everton			0	Wigan			1
Update 7

Copy of Table.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
23			Home					Away
24		P	W	D	L	F	A	W	D	L	F	A	GD	Pts
25	Chelsea	7	4	0	0	9	1	3	0	0	5	0	13	21
26	Charlton	6	1	0	1	1	2	4	0	0	9	2	6	15
27	Bolton	7	2	1	1	3	1	2	1	0	5	3	4	14
Update 7

 

[just_jon]

Book1
	A	B	C	D	E
1	11/4/2005	Chelsea	2	Aston Villa	1
2	11/4/2005	Everton	0	Wigan	1
3
4
Sheet2

Book1
	A	B	C	D	E	F	G
1		Home			Away
2	Team	W	D	L	W	D	L
3	Chelsea	0	0	0	1	0	0
4	Bolton	0	0	0	0	0	0
5	Aston Villa	0	0	1	0	0	0
6	Wigan	1	0	0	0	0	0
7	Everton	0	0	0	0	0	1
Sheet3

 

[cjsmith22]

thanks just_jon - the problem i've got is that the macro needs to be able to run successfully for any number of teams in a league and any set of results and i'm not sure how it can be done.