![]() |
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