Excel for Mac 2011 equivalent of ctrl+shift+j

[benje02]

I am trying to use Find and Replace to find the pipe symbol (|) and replace this with a carriage return. The ctrl+shift+j does not work for me on the Mac keyboard using Excel 2011 for Mac.

If I go into my VM running windows and Excel, then it works just fine.

Thanks,
Benje02

 

[Jim Gordon]

You can display the Find and Replace dialog with Command-F. But you’ll run into a problem because you can’t press the Carriage Return key in the Replace field because it activates the search. You can get around the problem by using a macro like:

Sub ReplacewithCR()    
Cells.Replace What:="|", Replacement:=Chr(13), LookAt:=xlPart, SearchOrder _
        :=xlByRows, MatchCase:=False
End Sub

Click here for more about Excel keyboard shortcuts.