Tidy a list

[MarkAndrews]

I have the following list which i would like to just show the names

Is there an easy way to do this other than using Text To Columns?

thanks

Generic Exchanges.xls
	E	F	G	H
2	AlyaYasmin(S&PFE-BRD)
3	BarbaraVickers(S&PFE-BRD)
4	BenKelly(S&PFE-BRD)
5	CaroleDishman(S&PFE-BRD
6	CavelNichols(S&PFE-BRD)
7	DamianHarrison(S&PFE-BRD
8	DanielleCruise(S&PFE-MAN)
9	DaoudHussain(S&PFE-BRD)
10	EstherYoung(S&PFE-MAN)
11	GwilymDavies(S&PFE-MAN)
12	HelenHorner(S&PFE-BRDH/
13	HelenManning(S&PFE-BRD)
14	HelenaReeve(S&PFE-BRD)
15	JamieCruise(S&PFE-MAN)
16	JaniceCopley(S&PFE-BRDH
Workings

 

[MarkAndrews]

Dominic - You are a star mate!! (& I know your really busy today, thanks for taking the time to help me)

One other quick question, is there anyway to ignore column E if this is '0' & just return the total? EG - 20 from the above example?

Thanks v much mate

 

[DominicB]

Hi Mark

Try :

=IF(E2=0,F2,CONCATENATE(F2,"(" &E2,$H$1&")"))

HTH

DominicB

 

[MarkAndrews]

Just thought of the IF - Mind is not on things today

Thanks for your ever valued help Dominic

 

[MarkAndrews]

=IF(E18="0"=TRUE,F18,CONCATENATE(F18,"("&E18,$H$1&")"))

E18 is 0, but it is not simply returning the total in F, which is 17

??????

 

[MarkAndrews]

E18, is a formual which returns 0

Is this why?

 

[MarkAndrews]

E18, is a formual which returns 0

Is this why?

 

[DominicB]

Hi Mark

Just thought of the IF - Mind is not on things today

You really need this holiday, don't you mate?

Not so much the formula, as the result. It is numerical and from the formula you quoted back at me, you enclosed the 0 in quotes - "0". Remove the quotes from the 0. That should work it out.

HTH

DominicB

 

[MarkAndrews]

Thanks mate, really appreciate

& Yes, Certainly do need this holiday!

 

[MarkAndrews]

Ignore this please

 

[DominicB]

Hi Mark

Is there a reason for this?

Yes, there is. The formula is in C2 and looks at A3 expecting to find a "(" in there somewehere. A3 contains Andrew Arnold - no brackets, hence the error.

HTH

DominicB