Concatenate function adding double quotes to both ends of results

S

SqtYork

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statement 2
Long formula 17
If condition to find Target 1
how do I fix #DIV/0! error? 1
Combination to Two formulas with the Help of AND / OR / IF Functions 1
Joining Two formulas with the Help of AND / OR / IF Functions to getthe desired result 1
A staying on schedule formula: 2
Adding numbers from other sheets? 2

Top