The guy working on my website has asked could i create a new column with the data from column D contained between inverted commas.
This stops the website from having issues with special characters
Ive included 2 workbooks, now , which is the current workbook and , proposed, how I would like it to look
Any help appreciated
This:Formula:
Please Login or Register to view this content.
Copy and Paste Special | Values over the originals and delete the formula output.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Or an alternative https://smallbusiness.chron.com/put-...cel-27534.html
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Just discovered VALUETOTEXT
Formula:Please Login or Register to view this content.
https://exceljet.net/functions/valuetotext-function
The VALUETOTEXT function converts a value to a text string. By default, text values pass though unaffected. However, in strict mode, text values are enclosed in double quotes (""). VALUETOTEXT will always remove number formatting applied to numeric values regardless of format.
The VALUETOTEXT function takes two arguments: value and format. Value is the value to convert to text. The format argument controls the structure of the output. By default, format is zero and VALUETOTEXT will output a "concise" format text value, essentially the normal format that Excel will use to display any text value. When format is set to 1 (strict format), text values will be enclosed in double quotes ("").
Is this resolved?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Hi folks, thank You so much for your help so far and sorry for the delay in replying but I was on site laying bricks all day.
From my perspective both solutions work perfectly but the guy working on my website is extracting the information from the work book as a text file and getting 3 sets of inverted commas instead of one.
I see "Tiesto & Judge Jules Live In Dublin (03.02.2001)"
he sees
,"""Tiesto & Judge Jules Live In Dublin (03.02.2001)""",
he needs to see the same as i do just one set starting and one closing, is it something Im doing my end?
Thanks in advance
Slightly confusing that the profile says 365 but the file format used in post #1 is .xls which was used for Excel 97 - 2003, so I wonder if trying to use formulas with 365 functionality may be the issue.
Try pasting the following into cell E2 and copying down to cell E9:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks