concatenate if

rubyh

Board Regular
Joined
Mar 31, 2006
Messages
213
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
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
I sort of get what you mean, but can you give us a couple of examples just to be sure...
 

rubyh

Board Regular
Joined
Mar 31, 2006
Messages
213
Book2
ABCD
1data1data2data3FORMULAFIELD
2MeMe
3MeMyselfMe-Myself
4MeMyselfIMe-Myself-I
Sheet1
 

Doug.T

Board Regular
Joined
Sep 19, 2006
Messages
80
How about....

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

rubyh

Board Regular
Joined
Mar 31, 2006
Messages
213
im seriously mentally ILL i dont why i didnt think of that.. thanks for the mind jolt.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,638
Members
410,805
Latest member
Ginoji
Top