replace comma with alt+enter

[user9]

Hi everyone,

How can I replace a comma with alt+enter?

I have several words separated with commas in a cell, but they should be on separate lines. Find/Replace doesn't work too well since I don't know how to enter alt+enter.

Does anyoen have an idea?

Thanks in advance

 

[Scott Huish]

In the Replace box:
Under Find, put a ,
Under Replace, hold down the Alt key and from the number keypad type 010

 

[erik.van.geit]

Hi, user9
Welcome to the Board !!!

in the replacementbox write 010 while pressing the ALT-key
(you won't see appear anything)

this works for me

kind regards,
Erik

EDIT: Chr(10) is the equivalent for Alt+Enter

 

[user9]

Thanks a lot for the replies HOTPEPPER and erik.van.geit, and thank you for the welcome.

How did you figure out the following?
alt+010 = alt+enter
CHR(10) = alt + enter

 

[erik.van.geit]

there are tables for this in the helpfiles
look for CHR or ASC or ASCII

I used this after typing Alt+Enter in a cell

Sub test()
MsgBox Asc(Left(ActiveCell, 1))
End Sub

 

[user9]

Thank you very much erik.van.geit

 

[babycody]

To find the code for any character type it in a cell, say A1. In another cell type =CODE(A1) . This will give you 10 for Alt+Enter. You usually have to add a zero infront of the number when entering it as prescribed above. This is a handy trick to know when trying to use special characters in a custom format. If you want to see the code of every character you can enter =CHAR(ROW()) into say A1 again. Click and hold on the right corner of the cell dragging it down til you receive a VALUE error around row 255. The row number is the character code. Try this with different fonts to get different characters i.e. Wingdings.

 

[erik.van.geit]

babycody,

fine! there was to much VBA-code in my head yesterday

 

[babycody]

babycody,

fine! there was to much VBA-code in my head yesterday

Well you know I must have been board to type that lengthy explanation. I just like helping the new members the way other members here have so graciously helped me. If you have too much VBA in your head I'll gladly take some off your hands.

 

[erik.van.geit]

I must have been board

was "board" a voluntary typo or are you just "high" of this Board