Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Replace command for replacing a character by an ALT+ENTER
Hi,
I have a large number of cell entries, all separated by a "/", but I need to replace it by "ALT+ENTER" (the keys sequence one uses for placing several expressions within the same cell onto separate lines of that same cell). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Replace command for replacing a character by an ALT+ENTER
"Peter from Novartis" wrote:
I have a large number of cell entries, all separated by a "/", but I need to replace it by "ALT+ENTER" (the keys sequence one uses for placing several expressions within the same cell onto separate lines of that same cell). Assume source data in A1 down In B1: =SUBSTITUTE(A1,"/",CHAR(10)) Format B1 to wrap text*, then Copy B1 down as far as required *Click Format Cells Alignment tab Check "Wrap text" OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Replace command for replacing a character by an ALT+ENTER
Hi Peter,
With the cursor in the Replace With box: hold down the ALT key and type the digits 010 on the numeric pad (it must be the numeric pad - a pain on a laptop!) This enters the non-printing character LF which is what is needed (it will not show in the box) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Peter from Novartis" <Peter from wrote in message ... Hi, I have a large number of cell entries, all separated by a "/", but I need to replace it by "ALT+ENTER" (the keys sequence one uses for placing several expressions within the same cell onto separate lines of that same cell). |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Replace command for replacing a character by an ALT+ENTER
One way might be to use an adjacent column =substitute(a2,"/",char(10)) and
format cells to word wrapthen change formula to values and delete the original column. or a macro to do it for you. -- Don Guillett SalesAid Software "Peter from Novartis" <Peter from wrote in message ... Hi, I have a large number of cell entries, all separated by a "/", but I need to replace it by "ALT+ENTER" (the keys sequence one uses for placing several expressions within the same cell onto separate lines of that same cell). |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Replace command for replacing a character by an ALT+ENTER
a macro Sub changetowrap() For Each c In Selection c = Application.Substitute(c, "/", Chr(10)) Next c Selection.WrapText = True End Sub -- Don Guillett SalesAid Software "Peter from Novartis" <Peter from wrote in message ... Hi, I have a large number of cell entries, all separated by a "/", but I need to replace it by "ALT+ENTER" (the keys sequence one uses for placing several expressions within the same cell onto separate lines of that same cell). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace 'alt + enter' key by single 'enter' | Setting up and Configuration of Excel | |||
shading a rowwhen a time is entered but no shading when 0 is enter | Excel Worksheet Functions | |||
Is there a (non-binary) "if x then enter y" forumula? | Excel Worksheet Functions | |||
How do I enter a slash character in excel? | Excel Discussion (Misc queries) | |||
How do I create a new symbol to enter as a character? | Excel Worksheet Functions |