Convert Multiple lines of text to Single line of text

Question

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

Answer 1

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.

Answer 2

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>