I created a concatenate function to build the columns out for an internal
wiki page. The page is a formated table of values. In order for the page to
format correctly I needed <CR in specific places.
At first I just went thru 40+ rows and adding two <CR by hand. Eventually
I got tired of that and added ,CHAR(13), to the CONCATENATE function

Looks great, except that when I copy paste the formula results, I end up
with extra " at the beginning and end of the values. Right now I just paste
it into notepad, find and replace " with nothing. Then copy paste those
results to the WIKI page.

Here are the results I currently get:
"|-
! 10.10.10.2
| LOCPPAPI01 || API Middleware || MOS || 19.3 || 219 || 10 || 10.10.20.2
|| Done || - || - || SP2
|-"

here is the formula:
=CONCATENATE("! ",B7,CHAR(13)," | ",C7," || ",D7," || ",E7," || ",F7," ||
",G7," || ",H7," || ",I7," || ",J7," || ",K7," || ",L7," || ",M7,CHAR(13),"
|-")


Any Suggestions?