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
Comments
|To-Increase|
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
Click on the cell. Then click on the top window where the text is showing and copy it from there.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
viewtopic.php?f=23&t=36073