web

You’re offline. This is a read only version of the page.

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

I have the same question (0)

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"

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 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?

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans