var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Need to eliminate CRLF (soft return) within a single cell in all rows.
User entered Address 1 and Address 2 data in Address 1 cell.
Sheet has over 800 lines, so manually repairing is right out!
Anyone have a VB sample subroutine?
String Replace will search for the string and replace all. You do not need to test for the existance of the find value. If the find value is not in the string it does not fail.
strTxt = Replace(strTxt, Chr(10), " ")
strTxt = Replace(strTxt, Chr(13), " ")
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors