Need long space, dots or dashes b/w two values

hi guys,
I am working on a sheet but I have a problem. I need a formula which show a line, dots or long space between two values.
If
A=ABC, B=100, C=2, D=2 & E=IF(C1=D1,A1&B1,"") which gives the result as ABC100 but I want
ABC..............100 or
ABC--------------100 or
ABC 100

sample sheet is attached.
help please

Try:

=IF(D1=C1,A1&REPT(".",10)&B1,"")


replace the 10 in REPT(".",10) with number of dots (or other character) you want.

Excellent....thank you so much NBVC

Originally Posted by NBVC

Try:

=IF(D1=C1,A1&REPT(".",10)&B1,"")


replace the 10 in REPT(".",10) with number of dots (or other character) you want.

need some help on that formula
if cells A1 & B1 are empty, this formula shows 0 value. I want that if A1 and B1 are empty then E1 should empty also.

tRY:

=IF(D1=C1,IF(AND(A1="",B1=""),"",A1&REPT(".",10)&B1),"")

Originally Posted by NBVC

tRY:

=IF(D1=C1,IF(AND(A1="",B1=""),"",A1&REPT(".",10)&B1),"")

this formula works perfect but in my sheet values in A1 and B1 are coming from other source and these cells are formatted as <Custom.....0;-0;;@> to hide zero value of these cells and this formula shows E1 value 0 not empty.

How about?

=IF(D1=C1,IF(SUM(A1,B1)=0,"",A1&REPT(".",10)&B1),"")

Originally Posted by NBVC

How about?

=IF(D1=C1,IF(SUM(A1,B1)=0,"",A1&REPT(".",10)&B1),"")

WOW its amazing, works like magic.....thank you