Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > ALT+0010 for Mac Excel / find replace

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

ALT+0010 for Mac Excel / find replace

Reply to Message Icon

Name: relleum
Date: April 30, 2009 at 10:47:23 Pacific
OS: Macintosh
Subcategory: Document Management
Comment:

Hello All,

Just switched to mac and I am stuck in office Mac Excel with a find replace. Here is what I got:

* This product is greatZZZ* Save moneyZZZ* Buy it now

All viewable in one cell. I want to find ZZZ and replace with a carriage return to look like:

* This Product is great
* Save Money
* Buy it now

Any ideas for a new mac user?? thanks!!



Sponsored Link
Ads by Google

Response Number 1
Name: Mike (by mmcconaghy)
Date: April 30, 2009 at 11:43:19 Pacific
Reply:

I'm assuming you mean you want the string:

* This product is greatZZZ* Save moneyZZZ* Buy it now

Broken into three separate parts and placed in different cells.

If your string is in Cell A1 then place the following in:

Cell A2 =LEFT(A1,FIND("Z",A1,1)-1)

Cell A3 =LEFT(RIGHT(A1,LEN(A1)-FIND("Z",A1,1)-2),FIND("ZZZ",RIGHT(A1,LEN(A1)-FIND("ZZZ",A1,1)-3),1))

Cell A4 =RIGHT(A1,LEN(A1)-FIND("#",SUBSTITUTE(A1,"Z","#",LEN(A1)-LEN(SUBSTITUTE(A1,"Z","")))))

MIKE

http://www.skeptic.com/


0

Response Number 2
Name: relleum
Date: April 30, 2009 at 11:49:39 Pacific
Reply:

all items are in the same cell and must remain that way.


0

Response Number 3
Name: DerbyDad03
Date: April 30, 2009 at 12:04:23 Pacific
Reply:

You said you just switched to a Mac, implying you used to do this on a PC.

If that's the case, how did you do it on a PC?


0

Response Number 4
Name: relleum
Date: April 30, 2009 at 12:10:19 Pacific
Reply:

on pc it was so easy....

Find: "ZZZ"

Replace: alt+0010


0

Response Number 5
Name: Mike (by mmcconaghy)
Date: April 30, 2009 at 12:35:26 Pacific
Reply:

ASCII code 10 is a Line Feed character,
Try 13 which is a Carriage Return char.

MIKE

http://www.skeptic.com/


0

Related Posts

See More



Response Number 6
Name: relleum
Date: April 30, 2009 at 12:48:26 Pacific
Reply:

Thanks, but how is that typed properly in the replace field in excel?


0

Response Number 7
Name: DerbyDad03
Date: April 30, 2009 at 12:48:31 Pacific
Reply:

Do other Alt Codes work as expected?

Have you tried 010 instead of 0010?



0

Response Number 8
Name: Mike (by mmcconaghy)
Date: April 30, 2009 at 13:04:59 Pacific
Reply:

Make sure you have Word Wrap set, else all you'll see is a little box.

Both ASCII 10 and ASCII 13 work for me using Excel 2000.

MIKE

http://www.skeptic.com/


0

Response Number 9
Name: Mike (by mmcconaghy)
Date: April 30, 2009 at 13:17:50 Pacific
Reply:

If you take the three formulas I posted in Response 1 and combine them with CHAR(10) you'll also get what your looking for.
Here is the whole formula, but I think the forum software might not wrap correctly:

=LEFT(A1,FIND("Z",A1,1)-1)&char(10)&LEFT(RIGHT(A1,LEN(A1)-FIND("Z",A1,1)-2),FIND("ZZZ",RIGHT(A1,LEN(A1)-FIND("ZZZ",A1,1)-3),1))&char(10)&RIGHT(A1,LEN(A1)-FIND("#",SUBSTITUTE(A1,"Z","#",LEN(A1)-LEN(SUBSTITUTE(A1,"Z","")))))
MIKE

http://www.skeptic.com/


0

Response Number 10
Name: relleum
Date: April 30, 2009 at 13:20:38 Pacific
Reply:

there is no "alt" key on a mac... that is how I got here. I hold down option and press 0010 and does not work.


0

Response Number 11
Name: DerbyDad03
Date: April 30, 2009 at 13:39:55 Pacific
Reply:

Tried Option and Shift?

This site seems to indicate that some ASCII codes use Option - Shift:

http://www.menekali.com/mac-alt-cod...


Also see the 1st response to the question asked here - the response explaining how to enable Unicode-Hex-Input.

http://forums.macnn.com/90/mac-os-x...


0

Sponsored Link
Ads by Google
Reply to Message Icon

multi language in office ... Paperport Professional 11...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: ALT+0010 for Mac Excel / find replace
MS Excel for MAC Find and Replace question www.computing.net/answers/office/ms-excel-for-mac-find-and-replace-question/9265.html

Word / Excel Viewer for Mac www.computing.net/answers/office/word-excel-viewer-for-mac/833.html

Find/Replace in Word 2003 www.computing.net/answers/office/findreplace-in-word-2003/5102.html