For this i have created a formula field (TEXT) and i copied billing street but it shows the same in 2 lines. how can i achieve this to show in single line.
21 answers
Actually Vinay came close. Here is the solution to remove line break in the billingstreet address.
Step 1. Create a custom label and name it linebreak ith a value of "
-
-" do not include the ".
Step 2. use this formula on your formula field#
SUBSTITUTE( BillingStreet ,SUBSTITUTE($Label.linebreak, "-", "")," ")
