Strange behavior of a formula

bknight
SilverLounger
Posts: 1679
Joined: 08 Jul 2016, 18:53

Strange behavior of a formula

Post by bknight »

I have a formula in a cell that concats sever cells and I'm getting a strange output.

Code: Select all

=UPPER(D5) & " " &B5&" CONTRACTS OF "&A5&" AT $"&C5&" "
Image is of the cell. Where does the added words after 21C come from and how do I get rid of them?
You do not have the required permissions to view the files attached to this post.

bknight
SilverLounger
Posts: 1679
Joined: 08 Jul 2016, 18:53

Re: Strange behavior of a formula

Post by bknight »

Never mind I just found all of the cells on that spreadsheet have the same incorrect text additions in the next row down in the wrap text fixed all of them.