Re: Replace a ; with alt+enter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ctrl + H, in the find what box type

;

click in the replace with box

hold down alt key and type 010 on the numpad

release alt

Replace


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"beginnerExceluser" <beginnerExceluser@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:16E4C9F2-A315-4BC5-A2BA-9D9D7114058B@xxxxxxxxxxxxxxxx
Can anyone explain how I could replace all the semi-colon's in a column
with
the equivalent of an alt+enter so that each value will appear on one line
within the cell?

I have a list of names that are separated by ; and I want to have each
name
on a separate line in the cell, without creating a new cell or row. So I
start out with

Smith, J;Smithe, C;Smythe, E

and I want to end up with:

Smith, J
Smither, C
Smythe, E

I would need to do this for all the cells in a particular column so if
there
is a way to repeat it that would be great. Each cell has a different
number
of names so I'd like something that looks in each cell in the column for a
;
and replaces it with a alt+enter and moves on to the next cell to perform
the
same task.

It seems like a simple task but it's driving me crazy, I'm doing it
manually
and I know there's a better way.

PS, the simpler the better, I don't know a lot about Macros and such.

Thank you.


.

Relevant Pages

  • Re: How do I setup a cell in Excel as a checkbox w/o a form/active
    ... Thanks Dave. ... When I press the alt key, no text is written to the screen. ... Don't forget to format the cell as wingdings. ...
    (microsoft.public.excel.misc)
  • Re: How do I setup a cell in Excel as a checkbox w/o a form/active
    ... I see the u-umlaut in the formulabar as soon as I let go of the alt key. ... "Dave Peterson" wrote: ... Don't forget to format the cell as wingdings. ...
    (microsoft.public.excel.misc)
  • Re: Using Replace command for replacing a character by an ALT+ENTER
    ... With the cursor in the Replace With box: hold down the ALT key and type the ... This enters the non-printing character LF which is what is needed ... I have a large number of cell entries, all separated by a "/", but I need ... expressions within the same cell onto separate lines of that same cell). ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Can you Add Check Boxes??
    ... But hit and hold the alt key while you're typing the 0252 from the numeric ... Hit the delete key on the keyboard to clear the cell. ... check boxes being marked have that row turn a different color and maybe ...
    (microsoft.public.excel.programming)
  • Re: Help with formula
    ... Hold down the ALT key and use the numeric keypad and type 010 ... Cell A1 has all this information in it Detail Feature Dia, ...
    (microsoft.public.excel.worksheet.functions)