Share via

Convert Multiple lines of text to Single line of text

Question

Tuesday, June 12, 2012 2:41 PM

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

All replies (3)

Tuesday, June 12, 2012 3:40 PM âś…Answered | 1 vote

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.

Tuesday, July 31, 2012 6:28 AM | 9 votes

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>

Wednesday, December 7, 2016 6:44 PM

Yes. Brilliant.