Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove commas from Windows buffer
Hi,
Does anyone have a quick macro for removing all commas in the Windows buffer before pasting into Excel ? The thing is, I'm copying from one program and pasting into Excel. However if the original copied text includes commas, it's going to screw up the pasting in Excel. Any ideas ? (c: Rasmus |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove commas from Windows buffer
Import it as comma delimited, maybe?
-----Original Message----- Hi, Does anyone have a quick macro for removing all commas in the Windows buffer before pasting into Excel ? The thing is, I'm copying from one program and pasting into Excel. However if the original copied text includes commas, it's going to screw up the pasting in Excel. Any ideas ? (c: Rasmus . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove commas from Windows buffer
Hi , Use the clip baord object to assign to a variable,
then use the REPLACE function to remove the commas, then assign the new string back to the clipbaord ready fro pasting.... Earl -----Original Message----- Hi, Does anyone have a quick macro for removing all commas in the Windows buffer before pasting into Excel ? The thing is, I'm copying from one program and pasting into Excel. However if the original copied text includes commas, it's going to screw up the pasting in Excel. Any ideas ? (c: Rasmus . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove Invereted Commas | Excel Discussion (Misc queries) | |||
I would like to remove IRM from windows | Excel Discussion (Misc queries) | |||
How Do I Add Commas To Columns And Remove Spaces In Excel?? | Excel Discussion (Misc queries) | |||
How to remove commas from a downloaded .dat file? | Excel Worksheet Functions | |||
How do I remove multiple windows of 1 workbook (filename.xls:2,:3 | Excel Discussion (Misc queries) |