Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2023, 03:02 AM
WudiTianxia WudiTianxia is offline How to put each word into one bracket Windows 10 How to put each word into one bracket Office 2021
Novice
How to put each word into one bracket
 
Join Date: Mar 2023
Posts: 3
WudiTianxia is on a distinguished road
Default How to put each word into one bracket

Hello,


I want to do the following thing but i didn't found how :


Word1, Word2, Word3, Word4 -> [Word1], [Word2], [Word3], [Word4]


Or if it's easier :



Word1 [Word1]

Word2 [Word2]

Word3 [Word3]

Word4 [Word4]


Colors just for more clarity, red before and green after.
Reply With Quote
  #2  
Old 03-13-2023, 07:51 AM
Charles Kenyon Charles Kenyon is offline How to put each word into one bracket Windows 11 How to put each word into one bracket Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Are you trying to transform the items in red to the same word except in brackets, or are you trying to group them?
Reply With Quote
  #3  
Old 03-13-2023, 07:59 AM
WudiTianxia WudiTianxia is offline How to put each word into one bracket Windows 10 How to put each word into one bracket Office 2021
Novice
How to put each word into one bracket
 
Join Date: Mar 2023
Posts: 3
WudiTianxia is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
Are you trying to transform the items in red to the same word except in brackets, or are you trying to group them?
I have a list of different words each separated by a comma and I want to put each of these words into brackets. So yeah in red those are the différents words I have and in green it's how I'd want those words to be.
I have a lot of words and it's a hassle to do manually so I wanted to know if there was a easier way to do it (I know the CTRL+H option but I have no idea how to format what I want to do)
Reply With Quote
  #4  
Old 03-15-2023, 09:57 AM
kilroyscarnival kilroyscarnival is offline How to put each word into one bracket Windows 10 How to put each word into one bracket Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

I would try highlighting the words and try:

FIND ", " (that is, a typed comma and a typed space)
REPLACE "], [" (that is, close bracket, comma, space, open bracket]

You would still have to open bracket your first word and close bracket your last one, but if there a bunch of comma-separated words in a string, that would do most of it rather simply.

If you are interested in a VBA solution, this thread may guide you there, as it's asking something similar, only with quotation marks. https://www.msofficeforums.com/word-...dd-single.html
Reply With Quote
  #5  
Old 03-16-2023, 01:34 PM
WudiTianxia WudiTianxia is offline How to put each word into one bracket Windows 10 How to put each word into one bracket Office 2021
Novice
How to put each word into one bracket
 
Join Date: Mar 2023
Posts: 3
WudiTianxia is on a distinguished road
Default

Quote:
Originally Posted by kilroyscarnival View Post
I would try highlighting the words and try:

FIND ", " (that is, a typed comma and a typed space)
REPLACE "], [" (that is, close bracket, comma, space, open bracket]

You would still have to open bracket your first word and close bracket your last one, but if there a bunch of comma-separated words in a string, that would do most of it rather simply.

If you are interested in a VBA solution, this thread may guide you there, as it's asking something similar, only with quotation marks. https://www.msofficeforums.com/word-...dd-single.html

Hello,
Thank you for your suggestion, i have tried it and it worked perfectly and allowed as well to understand better how the "find/replace" function works. Thank you as well for the link, i do am interested as well seeing a VBA solution.
Have a nice day.
Reply With Quote
Reply

Tags
bracket

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional format for NCAA bracket JoemanNville Excel 0 03-25-2019 01:45 PM
How to put each word into one bracket Remove repeated number after square bracket jeffreybrown Word VBA 8 12-04-2018 06:01 PM
Inside Bracket Formula tabulation question 27Cool44 Excel 2 02-11-2018 07:40 AM
Word 2010 - Remove square-bracket encased string in large document IntestinalWorm Word 1 06-20-2017 01:14 AM
Problem in Size of bracket[] and Parenthesis() ali-M Word 0 12-04-2016 02:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:34 AM.


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