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

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


.

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


.