Cut & Paste from Excel

Big_D

Hi Mibuso Community

When I cut and paste from a MS Excel cell i.e. 180, into another MS product say Word it will copy 180 but when I copy into a field on a Navision form (also a MS product) I get the Line feed characters too 180<CR><LF>. I Know I can compare the imported field to eliminate the <CR><LF> characters but it is a pain to cover every field on every form ](*,) Is there a function or interface that I can use between Excel/Navision to eliminate the <CR><LF> characters and only see 180?

Thanks for your help as always

Cheers

Sog

cut the formula, not the cell

Big_D

Hi Sog

Thanks for the reply !

I know about copying formula only but am more looking for an input routine that will drop the <CR><LF> characters automatically as other MS Software packages do automatically!

Cheers

ara3n

when you copy, copy from upper window on top of excel instead from the cell.

Click on the cell. Then click on the top window where the text is showing and copy it from there.

garak

This question was also posted here by an other user:

viewtopic.php?f=23&t=36073