#1
|
|||
|
|||
Export cells
Guys, I don't know exactly to explain...
There are 3 colluns: planeType dip dipAzimuth Plane Type 2 6.78271055 252.6860352 Plane Type 1 24.51920319 74.16799164 I need to copy theses informations like that: Plane Type 2 Dip(Type 2) DipAzim(Type 2) Dip(Type 1) DipAzim(Type 1) I need a condition formula to put those informations side by side... Sorry the bad english! |
#2
|
|||
|
|||
Usually the & symbol is used there. =A1&A2 will put the text from A1 and A2 together in the same cell. If you want to add your own formatting text, you can do it the same way -
for example, use =A1&" "&A2 to add a space. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook export does not export all fields for events in calendar | DAC8190 | Outlook | 0 | 08-22-2017 04:53 PM |
Conditional formating all cells in an array based on adjacent cells | deejay | Excel | 6 | 12-20-2016 12:00 PM |
Linking cells: can sub-cells move with their master-cell when sorting? | kw01 | Excel | 1 | 06-30-2015 05:02 PM |
Copying text range of cells to different cells adds an extra line | jpb103 | Word VBA | 2 | 07-23-2014 12:22 PM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |