ou81aswell
Board Regular
- Joined
- Oct 6, 2009
- Messages
- 50
I have a colleague in Paris who is running Excel 2010 under Windows/ Parallels on a Mac.
He has a number of cells which contain double spaced addresses (multiple carriage returns).
Example:
123 Main Street
Atlanta
Georgia
He's trying to remove the double spacing so it turns out like:
123 Main Street
Atlanta
Georgia
On my computer I can use Excel's replace feature and specify that it replace 2 CR's with a single CR by holding down the Alt key and typing 013 on the numeric keypad to specify the carriage return character. We can't figure out how to do this on a Mac since it doesn't have a numeric keypad.
Is there a macro that I could build that would do this automatically for the currently selected cells in Excel?
Alternatively, does anyone know how to enter ascii key codes via the Mac keyboard under Parallels?
Thanks.
He has a number of cells which contain double spaced addresses (multiple carriage returns).
Example:
123 Main Street
Atlanta
Georgia
He's trying to remove the double spacing so it turns out like:
123 Main Street
Atlanta
Georgia
On my computer I can use Excel's replace feature and specify that it replace 2 CR's with a single CR by holding down the Alt key and typing 013 on the numeric keypad to specify the carriage return character. We can't figure out how to do this on a Mac since it doesn't have a numeric keypad.
Is there a macro that I could build that would do this automatically for the currently selected cells in Excel?
Alternatively, does anyone know how to enter ascii key codes via the Mac keyboard under Parallels?
Thanks.