Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-02-2018, 09:44 AM
Mari Mari is offline Export cells Windows 7 64bit Export cells Office 2016
Novice
Export cells
 
Join Date: Feb 2018
Posts: 1
Mari is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 02-02-2018, 09:46 AM
Alsadius Alsadius is offline Export cells Windows 7 64bit Export cells Office 2010 64bit
Novice
 
Join Date: Nov 2017
Posts: 25
Alsadius is on a distinguished road
Default

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.
Reply With Quote
Reply



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
Export cells 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

Other Forums: Access Forums

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