Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2021, 05:52 AM
Mattc1978 Mattc1978 is offline I am populating a word template using MS Forms and the answers show with brackets and speech marks. Windows 10 I am populating a word template using MS Forms and the answers show with brackets and speech marks. Office 2019
Novice
I am populating a word template using MS Forms and the answers show with brackets and speech marks.
 
Join Date: May 2021
Posts: 13
Mattc1978 is on a distinguished road
Default I am populating a word template using MS Forms and the answers show with brackets and speech marks.

I am populating a word template using power automate from forms, can i remove the comma and speech brackets after the docx document is created and keep the content?


The commas and brackets come from prefilled responses and drop downs in the form.
Please Help!!!
Attached Files
File Type: docx 123456789.docx (55.1 KB, 6 views)
Reply With Quote
  #2  
Old 05-12-2021, 02:40 PM
macropod's Avatar
macropod macropod is offline I am populating a word template using MS Forms and the answers show with brackets and speech marks. Windows 10 I am populating a word template using MS Forms and the answers show with brackets and speech marks. Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It would be better to remove those 'features' before adding them to the form. You have two options:
1. Switch to 'Design Mode' and edit each content control manually; or
2. Use a macro to edit each content control's 'placeholder text'.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-13-2021, 12:12 AM
Mattc1978 Mattc1978 is offline I am populating a word template using MS Forms and the answers show with brackets and speech marks. Windows 10 I am populating a word template using MS Forms and the answers show with brackets and speech marks. Office 2019
Novice
I am populating a word template using MS Forms and the answers show with brackets and speech marks.
 
Join Date: May 2021
Posts: 13
Mattc1978 is on a distinguished road
Thumbs up :idea: I think I resolved the issue, I am about to make my first macros that will involve:

Convert .docx to .doc and this removes the active fields - I might be able to do this in Power Automate, will have to see.

Ctrl A - right click century gothic and apply to all text as the default from MS forms is Times New Roman; followed by Ctrl H find [[,"\]] wildcard option replace all, and nothing as a replacement, and finally find None and replace all with nothing.

This clears up all the gumpf from the MS form input and then clears the form up to be converted to a PDF to be posted for people to see.

If anyone has a better solution please tell me.
Reply With Quote
  #4  
Old 05-13-2021, 12:19 AM
Mattc1978 Mattc1978 is offline I am populating a word template using MS Forms and the answers show with brackets and speech marks. Windows 10 I am populating a word template using MS Forms and the answers show with brackets and speech marks. Office 2019
Novice
I am populating a word template using MS Forms and the answers show with brackets and speech marks.
 
Join Date: May 2021
Posts: 13
Mattc1978 is on a distinguished road
Thumbs up Thanks for the Reply

Quote:
Originally Posted by macropod View Post
It would be better to remove those 'features' before adding them to the form. You have two options:
1. Switch to 'Design Mode' and edit each content control manually; or
2. Use a macro to edit each content control's 'placeholder text'.
Pretty much what I did in the end with a few more add ins, basically this whole endeavor is a bit odd because of all the converting, but hopefully I have come up with a design solution for the whole project with Zero coding experience and gone from a MS form, saved the data as a SharePoint list, Excel sheet, created and populated a Word template, created a word document for quality assurance, converted to PDF and emailed the quality assurance officer that there is a new submission.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel converting answers to dates from Google Forms oliboi Excel 2 12-04-2019 04:21 AM
I am populating a word template using MS Forms and the answers show with brackets and speech marks. find and delet all text within brackets and the brackets themselves wrdy Word 2 08-03-2017 06:55 PM
I am populating a word template using MS Forms and the answers show with brackets and speech marks. How do I fix this unknown problem? Right-angle marks in corners - crop marks Quillo1234 Word 2 07-20-2016 02:24 AM
Ms Word Template with VBA forms not working in SharePoint KangarooJack Word VBA 0 01-28-2016 02:11 PM
Weird extra spacing when using speech marks in Word 2007? Apocsol Word 1 08-10-2015 06:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft