Text in cells

[schooll]

I need help with excel. As you can see at the top I have 3 rows (*Rad bravara... *rad električara… * prekidi...) but in the cell(2022-05-10; 170) I have everything in one row. Do you know some shortcut to make it all in one row at the top as well. I need to put that in one program and it doesn't recognize it while it is in 3 rows, 2 or 4. And I cant manually delete rows because I have them to many.

 

[Alex Blakenburg]

If I understand you correctly you have Line Feeds in some of the cells in you description column and you want to get rid of them.

If that is correct then
• select the description column
• press Ctrl+H to call up the Find & Replace dialogue box
• in the Find What box type Ctrl+J
(It won't seem to do much but there will be something there and it will represent a Line Feed)
• In the replace with box, I would suggest putting in a space.
• Then hit replace all.

See if that gives you the result you are after.

 

[schooll]

If I understand you correctly you have Line Feeds in some of the cells in you description column and you want to get rid of them.

If that is correct then
• select the description column
• press Ctrl+H to call up the Find & Replace dialogue box
• in the Find What box type Ctrl+J
(It won't seem to do much but there will be something there and it will represent a Line Feed)
• In the replace with box, I would suggest putting in a space.
• Then hit replace all.

See if that gives you the result you are after.

thank you so much

 

[Alex Blakenburg]

You're welcome. Glad I could help.