Remove extra lines within cell

Question

I have downloaded data into an excel worksheet from my bank website.  Each cell contains several lines of text with one extra return space:

NONREF

VENDOR NAME

TR FM ####-####-### AT 32.07

L/O 02.08.10 FX USD 1800000.00

AT 32.0700000

After "NONREF" and before "VENDOR NAME" there is an extra return line.  I would like to search for and delete these extra returns.  How can I do this without manually deleting them per cell.

TIA, LisaVH

Answer 1

If you want to change:

NONREF

VENDOR NAME

to

NONREF

VENDOR NAME

(those exact strings!)

You can select the range

Edit|replace

what:  NONREF(ctrl-j)(ctrl-j)VENDOR NAME

with:  NONREF(ctrl-j)VENDOR NAME

replace all

The ctrl-j characters (hold the control key while hitting j) are the equivalent

of the alt-enter (char(10)) characters.

The edit|replace dialog may look weird when you're doing it, but try it.  You'll

like it!

Lisavh wrote:

I have downloaded data into an excel worksheet from my bank website.  Each cell contains several lines of text with one extra return space:

NONREF

VENDOR NAME

TR FM ####-####-### AT 32.07

L/O 02.08.10 FX USD 1800000.00

AT 32.0700000

After "NONREF" and before "VENDOR NAME" there is an extra return line.  I would like to search for and delete these extra returns.  How can I do this without manually deleting them per cell.

TIA, LisaVH

--

Dave Peterson

Answer 2

Hello,

I too have a spreadsheet that has returns after individual vendor names that require to be deleted.  I tried the suggestion above and it has not worked for me.  I do not know if i have done something wrong or if the fact that I am using Office 2007 makes a difference.

Can anyone help me?

Answer 3

I would guess that (ctrl-j)(ctrl-j) would have been a better choice.  Then the

lines that are ok won't be changed.

Lisavh wrote:

I don't want to change any of the information in the cell...only delete the extra line. I paraphrased the data in the cell.  "Vendor Name" is actual data, not the exact text string. Sorry if I was unclear.

Can I do the same thing, just using just "(ctrl+j)"??

LisaVHedit to add....just tried a find/replace using ctrl+J and it worked! Thank you thank you!

--

Dave Peterson

Answer 4

I don't want to change any of the information in the cell...only delete the extra line. I paraphrased the data in the cell.  "Vendor Name" is actual data, not the exact text string. Sorry if I was unclear.

Can I do the same thing, just using just "(ctrl+j)"??

LisaVH

edit to add....just tried a find/replace using ctrl+J and it worked! Thank you thank you!