Alingment of text in one cell

[boka9025]

Hello. I have problem when try to align my text on both sides in cell ( justify) I get to big spaces between word. I have atached picture which is better describeing what is my goal. https://ibb.co/Rcfxm2n

 

[steve the fish]

Hi. Im afraid those are your choices. Left align, right align, centre or justify. If you dont like the look of it your other options are to resize the cell or alter the text size until you do like it but of course that varies with the amount of text.

 

[boka9025]

I have seen one method and it is by function Find. It finds big spaces and replaces it with small, but i didn't manage to pull this off in right way. If anyone has any idea I would be grateful.

 

[steve the fish]

Those are not 'big spaces'. A space is a space. They are spaces that you have asked to justify across the cell width. If your 'big space' became small then you just end up with left alignment.

 

[boka9025]

https://ibb.co/tq7mL0X is there any way that excel doesn't throw this word ( marked with blue arrow) on new line. I have tried to write shorter word in that line but it still throws it in new line, even though there is enough spacefor that word.

 

[steve the fish]

Your options ive outlined above. If it moves to a new line its because there isnt enough space even if you think there is.

 

[Peter_SSs]

Try this.
- Select the cell (or whole column). It actually looks like you are dealing with merged cells but that shouldn't matter.
- Press Ctrl+H to bring up the Find and Replace dialog
- In the Find what: box ensure anything already there is deleted and then type a space in that box
- In the Replace with: box ensure anything already there is deleted and then hold the Alt key and type 0160 on the numeric keypad at the right of the keyboard, not the upper row of keys above QWERTY...
- In Options >> ensure 'Match entire cell contents' is not checked
- Replace All
- Ensure the cell formatting is set to 'Wrap Text'

Now try resizing the column width.

 

[boka9025]

Thank you that is what i was looking for.

 

[Peter_SSs]

Thank you that is what i was looking for.

You're welcome. It replaces all the space characters with non-breaking space characters, effectively making the text in the cell into just one long 'word'. That forces Excel to simply wrap at the point(s) where the long 'word' meets the cell boundary.