Skip to main content
App Shark 님이 #Ask An Expert에 질문했습니다
I have a requirement to show billing Street in a single line.

 

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개
  1. 2016년 11월 15일 오후 1:28
    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, "-", "")," ")

     

     
0/9000