Find and replace in Excel X for Mac

[Dobo]

Using Excel X for Mac, I'd like to find all commas in a column and
replace them with hard returns/carriage returns (not soft returns).
Since Excel doesn't recognize the Cntrl-Option-Return combo when I use
the Replace function, I'm guessing I'll have to use a formula or a
macro. I've seen several great suggestions for PC users, but none for
Mac users.

Thanks.

 

[Cindy M -WordMVP-]

Hi Dobo,

Using Excel X for Mac, I'd like to find all commas in a column and
replace them with hard returns/carriage returns (not soft returns).

Might be a good idea to ask this in a group specific for Excel,
rather than Word... there's even an excel.macintosh group on this
server.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail