concatenate if

[rubyh]

Im trying to concatnate 3 cells together in a row, However if for example data is in
A2, B2, i dont want it to return C2 if its blank and i would like to place a - (dash) in the middle between the cells when they are returned. I know theres a easy im just drawing ablank right now....
thanks ahead of time

 

[PaddyD]

I sort of get what you mean, but can you give us a couple of examples just to be sure...

 

[rubyh]

Book2
	A	B	C	D
1	data1	data2	data3	FORMULAFIELD
2	Me			Me
3	Me	Myself		Me-Myself
4	Me	Myself	I	Me-Myself-I
Sheet1

 

[Doug.T]

How about....

=A2&(IF(ISBLANK(B2),"","-"))&B2&(IF(ISBLANK(C2),"","-"))&C2

 

[rubyh]

im seriously mentally ILL i dont why i didnt think of that.. thanks for the mind jolt.