|
|
#2
03-23-2021, 09:32 AM
|
||||
|
||||
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. 
|
|
|
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 |
 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 |
|
How to get "Track Changes" to ignore "Field Code Changed"?
|
Joey Cheung | Word | 2 | 10-31-2014 07:55 PM |
|
Replacing a single "l" with a double "ll"
|
MShroff | Word | 8 | 01-19-2011 08:43 AM |
Windows 10 
Office 2016
Threaded Mode