find and repace

[dhulbert]

I'm trying to replace a cariage return (ascii 13) in cells spread all over a work book.
Anyone have a quick way of doing this please as find/replace wont work.
Cheers.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[AnotherHiggins]

Oh, but it will work!!

Let's say you want to replace | (pipe) with chr 13.

[Ctrl]+[H] to open the Find and Replace dialog box.

In the Replace with field, press and hold the [Alt] key, then using the number pad at the right of the keyboard, type in 0013.

You won't see anything appear - that's fine. Now Replace All.

PS - you might want to use 0010 instead.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[dhulbert]

I really mut remember to say I an't make it work beacuse there is always someone on here who can. Cheers

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)