# A good way to import line breaks from Excel?

**URL:** <https://www.epiusers.help/t/a-good-way-to-import-line-breaks-from-excel/102837>\
**Category:** Kinetic ERP\
**Tags:** dmt\
**Created:** [May 17, 2023, 1:14pm UTC](https://www.epiusers.help/t/a-good-way-to-import-line-breaks-from-excel/102837 "2023-05-17T13:14:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![TSH](https://www.epiusers.help/letter_avatar_proxy/v4/letter/t/c0e974/32.png) [@TSH](https://www.epiusers.help/u/TSH)\
**Post date:** [May 17, 2023, 1:14pm UTC](https://www.epiusers.help/t/a-good-way-to-import-line-breaks-from-excel/102837/1 "2023-05-17T13:14:34Z")

</div>

Hello,

I am loading data for a custom part description field from Excel. The descriptions contains line breaks. The data imports without error but I’ve been told that it’s an unprintable character and is causing occasional problems.

We need the line breaks. Is there something I can replace the char(10) with in Excel, or do we have to manually enter the correct line breaks in Epicor afterwards? I’m hoping it’s the former.

Thank you

---

<div class="post-metadata">

**Author:** ![dcamlin](https://www.epiusers.help/user_avatar/www.epiusers.help/dcamlin/32/57759_2.png) [@dcamlin](https://www.epiusers.help/u/dcamlin)\
**Post date:** [May 17, 2023, 1:17pm UTC](https://www.epiusers.help/t/a-good-way-to-import-line-breaks-from-excel/102837/2 "2023-05-17T13:17:02Z")

</div>

Are you trying to view the line breaks in an Epicor form? Or on a printed SSRS form?

---

<div class="post-metadata">

**Author:** ![TSH](https://www.epiusers.help/letter_avatar_proxy/v4/letter/t/c0e974/32.png) [@TSH](https://www.epiusers.help/u/TSH)\
**Post date:** [May 17, 2023, 1:17pm UTC](https://www.epiusers.help/t/a-good-way-to-import-line-breaks-from-excel/102837/3 "2023-05-17T13:17:58Z")

</div>

Both. The sales people check it on the screen to make sure it looks as it should, then it will be printed with the line breaks on the Purchase Order report

---

<div class="post-metadata">

**Author:** ![dcamlin](https://www.epiusers.help/user_avatar/www.epiusers.help/dcamlin/32/57759_2.png) [@dcamlin](https://www.epiusers.help/u/dcamlin)\
**Post date:** [May 17, 2023, 1:27pm UTC](https://www.epiusers.help/t/a-good-way-to-import-line-breaks-from-excel/102837/4 "2023-05-17T13:27:37Z")

</div>

I know on the SSRS side of things I’ve used the below expression to “replace” chr(10) and/or chr(13) with the more supported “VbCrLf”… which then should print your line breaks correctly.

=First(REPLACE(Fields!CommentText.Value, chr(13), VbCrLf))

---

<div class="post-metadata">

**Author:** ![TSH](https://www.epiusers.help/letter_avatar_proxy/v4/letter/t/c0e974/32.png) [@TSH](https://www.epiusers.help/u/TSH)\
**Post date:** [May 17, 2023, 1:36pm UTC](https://www.epiusers.help/t/a-good-way-to-import-line-breaks-from-excel/102837/5 "2023-05-17T13:36:58Z")

</div>

> [@dcamlin](#):
>
> VbCrLf

The issue is that although it appears to work on screen it’s causing problems in places like doing a Receipt Entry, so I’m wondering if there’s a way to get the data clean in the fields themselves.