Replace a character with a hard return

Joe1 · #1 (**permalink**) 06-14-07, 14:06

I’m using Excel 2002
Is it possible to replace a special character (or a combination of mutable) with a hard return? (Alt Enter)

Thanks

gvee · #2 (**permalink**) 06-14-07, 14:13

In VBA it should be possible
Here's some pseudo code

Code:

Replace(theText, "//", Chr(13) & Chr(10))
'Where // is our special character

Joe1 · #3 (**permalink**) 06-14-07, 14:17

Any way without VBA?
Thanks

gvee · #4 (**permalink**) 06-14-07, 14:21

Why not play with the above code outside of VBA?
You may wish to look this up in the help files in Excel.
Let us know how you get on!