| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cut / Paste with a Twist
A neat way of doing this is to create a thrd column which contains a concatentation of the first two. e.g. = A1 & B1 in cell C1 This has the effect of making a single column. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=560004 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Paste Special Problem | Excel Discussion (Misc queries) | |||
| Copy and paste Excel chart in Word -- font compresses | Charts and Charting in Excel | |||
| paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
| excel - numbers as text | New Users to Excel | |||
Hybrid Mode
