Formula not just quite right

P

Pat

This formula is not just right


=(SUBSTITUTE(TRIM(BP77&" "&BQ77),"",",")&" "&(TRIM(BW77))&"
"&(SUBSTITUTE(TRIM(CJ77&" "&CK77),"",",")&" "&(TRIM(BW77))))

When all cells contain date it should display
B10 B12 B5 C2 B8 D11

but instead it displays
B10 B12 B5 C2 B8 B5

B5 at the end seems to be repeated and replaces D11

Anyone know what is wrong?

Pat
 
J

Jason Morin

That's because you're pulling in the same cell, BW77,
twice. Change the last cell reference in the formula from
BW77 to whatever it needs to be.

HTH
Jason
Atlanta, GA
 
Top