[MacTUG] Excel - replacing soft returns

[Glenn Anderson]

The issue of how to replace "soft returns" in cells with something like a space came up in the meeting this morning.

There should be some way to do this with the find/replace command, but I can't seem to get it to work. I think I am suppose to be able to hold down the alt key and then enter 0011 on the numeric keypad, but that doesn't work.

Personally, I would likely write a macro to do this or use the substitute function as shown below:

[cid:CD48EBBB-05F1-451D-83D4-A59259535708 at uwaterloo.ca]



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.uwaterloo.ca/pipermail/mactug/attachments/20120131/b6488f2e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2012-01-31 at 4.13.35 PM.png
Type: image/png
Size: 13683 bytes
Desc: Screen Shot 2012-01-31 at 4.13.35 PM.png
URL: <http://lists.uwaterloo.ca/pipermail/mactug/attachments/20120131/b6488f2e/attachment.png>