Skip to main content
B
Bakin_Momma
Participant
January 18, 2020
Question

Creating Cookbook with data merge

  • January 18, 2020
  • 2 replies
  • 1280 views

My problem may be a simple one but it is driving me crazy! I am trying to create a family cookbook. I have all my recipes in an excel spreadsheet. When data merging, fields that have only one line merge just fine, but my fields with say directions (which is like a paragragh) nothing shows up. Please help!

This topic has been closed for replies.

2 replies

MW Design
MW Design
Inspiring
January 18, 2020

You'll need to find/replace the carriage returns with a character or symbol inside Excel. I typically use an AT (@) symbol, but it can be anything not used for text you intend to keep.

 

!Make a copy of your Excel file!

 

So inside Excel, press ctrl+h

This opens the find/replace dialog.

 

In the Find field, press ctrl+j

It will appear empty but you can just barely see what looks like a period in it.

 

In the Replace field, type your symbol, say the @ sign.

Then use Replace All.

 

You'll be able to do the merge, then in ID you can replace the character used to represent the return character to an actual hard return.

 

Mike

    B
    Bakin_MommaAuthor
    Participant
    January 19, 2020

    I'm on a Mac so my controls are slightly different but I get what you are saying, thanks I'll try that!

    Mario Fritsche
    Mario Fritsche
    Legend
    January 18, 2020

    Zeige mal deine Excel-Datei. Die Excel als .xls speichern.

    ---Mario
    B
    Bakin_MommaAuthor
    Participant
    January 19, 2020

    .xls doesn't work with data merge, unless I'm doing something wrong. Here is my file 

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices