| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste cells without tabs
I want to copy the contents of two horizotally adjacent cells, and paste the
contents to rename a file in Windows Explorer. However, the clipboard retains a tab character between the text in the cells. How can I copy and paste the cells as run-on text, without a tab character in between? (I want to avoid, if possible, creating a third column to concatenate the two cells.) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste cells without tabs
Because you are only copying two cells I would copy them one at a time. I
would then replace the tab with a space while copying a = Range("A1") b = Replace(a, Chr(9), " ") 'put b into window Explorer a = Range("B1") b = Replace(a, Chr(9), " ") 'put b into window Explorer "hmm" wrote: I want to copy the contents of two horizotally adjacent cells, and paste the contents to rename a file in Windows Explorer. However, the clipboard retains a tab character between the text in the cells. How can I copy and paste the cells as run-on text, without a tab character in between? (I want to avoid, if possible, creating a third column to concatenate the two cells.) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet tabs & cells | Excel Discussion (Misc queries) | |||
| PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS | Excel Discussion (Misc queries) | |||
| paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
| how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
| Can you copy multiple tabs from formulas to values w/o paste spec? | Excel Worksheet Functions | |||
Linear Mode
