| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy and Paste function
Good day!
I need a formula that I can use to take values in one row but different columns and merge them together into one line with the pipe symbol (|) separating the column values, for example: Column: A B C D E F 100 141 154 160 175 182 Becomes Column A B C D E F 100|141|154|160|175|185 I have been using the "&" function, but I can't seem to get the formula right. -- Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy & Paste value Function | Excel Worksheet Functions | |||
| disabling the copy paste function in a cell | Excel Worksheet Functions | |||
| cut,copy paste function | Excel Discussion (Misc queries) | |||
| prevent the copy and paste function | Excel Discussion (Misc queries) | |||
| Control function for copy/paste | Excel Worksheet Functions | |||
Threaded Mode
