Find replace string to replace with CR/LF

[bbbb1234]

I am attempting to move a table from Word to Excel. The way I used to do it in Windows as to replace ^p with xxxxxxxxxx in Word, copy and paste the table into Excel and then do a find/replace of xxxxxxxxxx with Alt 0010.

I am now using a Mac. I did the replace ^p with xxxxxxxxxx in Word, copy and paste the table into Excel. I can't find the equivalent of Alt 0010 for Mac to do the find and replace in mass. Anyone know the Alt 0010 on a Mac or have another way of transferring a table from Word to Excel and preserving the CR/LF?

 

[Fluff]

If your doing this with the Excel replace feature (Ctrl H) then try using Ctrl J instead of Alt 0010
Hoping it works on a Mac

 

[bbbb1234]

Ctrl J on the Mac does not work in Excel Ctrl H.

 

[Fluff]

What happens?

 

[Fluff]

It appears that you can't really do it. However you could use a macro like

Sub bbbb()
Cells.Replace What:="xxxxxx", Replacement:=Chr(10), LookAt:=xlPart, SearchOrder _
        :=xlByRows, MatchCase:=False
End Sub

 

[bbbb1234]

What happens?

My system just "beeps" at me - telling me it was an invalid keystroke.

 

[bbbb1234]

It appears that you can't really do it. However you could use a macro like

Sub bbbb()
Cells.Replace What:="xxxxxx", Replacement:=Chr(10), LookAt:=xlPart, SearchOrder _
        :=xlByRows, MatchCase:=False
End Sub

That is a HUGE bummer that it cannot be done without macros.

 

[Fluff]

I cannot be certain it cannot be done without a macro, as I don't have a Mac. But having done a quick search of the net, that seems to be the conclusion.