ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Concatenate function adding double quotes to both ends of results (https://www.excelbanter.com/excel-worksheet-functions/156949-concatenate-function-adding-double-quotes-both-ends-results.html)

SqtYork

Concatenate function adding double quotes to both ends of results
 
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?



All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com