none
Convert Multiple lines of text to Single line of text

    질문

  • Dear All,

    I have imported Excel Sheet to Custom list but all of the colomn is "Multiple lines of text". how can i conver it to "Single line of text" or "Choice" ?

    Besr Regards

    Lasantha

    2012년 6월 12일 화요일 오후 2:41

답변

  • Have you tried to create a new calculated column to transform your data? Try using the TEXT function, reference document is here http://office.microsoft.com/en-us/windows-sharepoint-services-help/examples-of-common-formulas-HA001160947.aspx

    -victor

    Be a part of the community, please remember to indicate if your question/comment has been answered or is helpful.

    2012년 6월 12일 화요일 오후 3:40

모든 응답

  • Have you tried to create a new calculated column to transform your data? Try using the TEXT function, reference document is here http://office.microsoft.com/en-us/windows-sharepoint-services-help/examples-of-common-formulas-HA001160947.aspx

    -victor

    Be a part of the community, please remember to indicate if your question/comment has been answered or is helpful.

    2012년 6월 12일 화요일 오후 3:40
  • I found that by changing the column properties from text to plain text, and number of lines to 1, and saving, then reopening, the option was there to change the multi-line to single line

    Reference

    Settings > Edit Column  

    <input CHECKED="checked" id="onetidRichTextPlain" name="RichText" title="Plain text" type="radio" value="PLAIN" />

    <label for="idNumLines">Number of lines for editing: </label> 
    <input name="NumLines" type="hidden" /> <input class="ms-input" id="idNumLines" maxLength="255" name="OWS:NumLines:Local" size="11" title="Number of lines for editing" type="text" value="1" />
      <label for="onetidRichText">Specify the type of text to allow:</label> 
    <input CHECKED="checked" id="onetidRichTextPlain" name="RichText" title="Plain text" type="radio" value="PLAIN" /> <label for="onetidRichTextPlain">Plain text  </label>
    <input id="onetidRichTextCompatible" name="RichText" title="Rich text (Bold, italics, text alignment)" type="radio" value="COMPATIBLE" /> <label for="onetidRichTextCompatible">Rich text (Bold, italics, text alignment)</label>
    <input id="onetidRichTextFullHtml" name="RichText" title="Enhanced rich text (Rich text with pictures, tables, and hyperlinks)" type="radio" value="FullHtml" /> <label for="onetidRichTextFullHtml">Enhanced rich text (Rich text with pictures, tables, and hyperlinks)</label>

    <label for="onetidRichTextPlain"></label>

    • 답변으로 제안됨 Jussi Palo 2014년 8월 5일 화요일 오후 12:30
    2012년 7월 31일 화요일 오전 6:28