Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2021, 08:02 AM
LearnerExcel LearnerExcel is offline To put "," after each code and make a single line... Windows 7 32bit To put "," after each code and make a single line... Office 2013
Advanced Beginner
To put "," after each code and make a single line...
 
Join Date: Nov 2016
Posts: 81
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default To put "," after each code and make a single line...

Hi,

I have several "TR_CODE" in several cells of a single row. I need there should be a "," after each "TR_CODE" automatically generated and it should be placed in a single line like in the picture.



Any help would be appreciated as I am in need of this code because there are a huge number of TR_CODES to put in a single row with adding a comma.
Attached Images
File Type: png Auto_Comma_after_each_TR_CODE.png (24.5 KB, 11 views)
Reply With Quote
  #2  
Old 03-23-2021, 09:32 AM
rollis13's Avatar
rollis13 rollis13 is offline To put "," after each code and make a single line... Windows 10 To put "," after each code and make a single line... Office 2016
Competent Performer
 
Join Date: Jan 2021
Location: Cordenons
Posts: 140
rollis13 will become famous soon enough
Default

Maybe it's not the quickest way to do what you require but it's the only way I know how to do it with formulas:
- enter this formula =CONCATENATE(TRANSPOSE(A2:A15)&",") in the cell where you want to join your "TR-CODE"s
- highlight this part of the formula TRANSPOSE(A2:A15)&","
- press F9 key to show the cell contents instead of the cell reference
- from the formula remove the two curly brackets (one at the beginning and one at the end) and the last comma (if you don't need it)
- press the Enter to confirm.
Reply With Quote
  #3  
Old 03-23-2021, 12:49 PM
Purfleet Purfleet is offline To put "," after each code and make a single line... Windows 10 To put "," after each code and make a single line... Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Please add a workbook rather than a picture - a picture just means that we have to manually recreate the data
Reply With Quote
  #4  
Old 03-23-2021, 01:00 PM
LearnerExcel LearnerExcel is offline To put "," after each code and make a single line... Windows 7 32bit To put "," after each code and make a single line... Office 2013
Advanced Beginner
To put "," after each code and make a single line...
 
Join Date: Nov 2016
Posts: 81
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default

Fantastic. It works fine. Thanks a lot for your kind help & support.

Noted: Next time I will take care to attach an Excel Sheet as advised.
Reply With Quote
  #5  
Old 03-23-2021, 01:56 PM
rollis13's Avatar
rollis13 rollis13 is offline To put "," after each code and make a single line... Windows 10 To put "," after each code and make a single line... Office 2016
Competent Performer
 
Join Date: Jan 2021
Location: Cordenons
Posts: 140
rollis13 will become famous soon enough
Default

Glad having been of some help .
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Magic" indentation for "too-long" text-lines that are longer than one line pGrnd Word 2 04-20-2020 03:23 PM
To put "," after each code and make a single line... How to make table of contents display a "summary line"? chatguy Word 7 08-21-2017 02:48 PM
Replace "comma" with "and" in line of text audioman Word VBA 7 01-21-2016 03:11 PM
To put "," after each code and make a single line... How to get "Track Changes" to ignore "Field Code Changed"? Joey Cheung Word 2 10-31-2014 07:55 PM
To put "," after each code and make a single line... Replacing a single "l" with a double "ll" MShroff Word 8 01-19-2011 08:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:42 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