News and Announcements icon

Dynamics 365 CommunityForums Finance forum How to insert a carria...

Finance forum

How to insert a carriage return (or line feed) in Address fields (Street address)

(0) Share

Report

Report

Posted on by Community Member

Hello,

I'm trying to insert with Excel files and Dataentities new Vendors for my company.

But in the STREET field, we want to have multi lines. I tried to put a "\n" in the Excel spreedsheat but It doesn't work.

3146.Capture.PNG

Have you an idea to help me ?

Thanks a lot

Categories:

Data Integration

All responses Img

All responses (2)

Answers Img

Answers (1)

Community Member on at

Like (0)

Report

RE: How to insert a carriage return (or line feed) in Address fields (Street address)

Thanks Nikolaos, it works.

And if you want to make concatenation in Excel files (for data catchup), you can use this kind of formula : = "aaaa"&CHAR(10)& "bbbbb"
Verified answer

nmaenpaa 101,156 Moderator on at

Like (1)

Report

RE: How to insert a carriage return (or line feed) in Address fields (Street address)

Not sure if it works with the data entity, but did you try putting actual line break (alt-enter) in your Excel cell?

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,304 Super User 2025 Season 1

#2

Martin Dráb 232,129 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans