Skip to main content

Tip: Address field display problem in Excel

  • January 4, 2021
  • 0 replies
  • 39 views

ADNAN
Sidekick
Forum|alt.badge.img+8

Hello

 

 

When the address field is printed out in excel, it moves to the next line. You can fix this error with existing code.

replace(t.address ,chr(13)|| chr(10),'' ) '' )

 

 

The address field contains ASCII code. Chr (13) || He was doing it with the chr (10) CODE. You can fix this problem with the Replace command.

 

This topic has been closed for replies.