It is often required inside one Excel cell to wrap text on new line. That is, move the text line by line within one cell as shown in the picture. If, after entering the first part of the text, simply press the ENTER key, then the cursor will be moved to the next line, but in a different cell, and we need to move in the same cell.

This is very frequent task and it is solved very simply - to wrap the text to a new line inside one Excel cell, you must press ALT+ENTER(hold down ALT key, then without releasing it, press the ENTER key)

How to move text to a new line in Excel using a formula

Sometimes you need to do a line break not once, but using functions in Excel. Like in this example in the picture. We enter the first name, last name and patronymic and it is automatically collected in cell A6

In the window that opens, in the "Alignment" tab, you must check the box next to "Wrap by words" as shown in the picture, otherwise line wrapping in Excel will not be displayed correctly using formulas.

How to replace the hyphen in Excel with another character and vice versa using a formula

Can change the hyphen character to any other character, for example to a space, using text function SUBSTITUTE in Excel

Consider the example in the picture above. So, in cell B1 we write the SUBSTITUTE function:

SUBSTITUTE(A1,CHAR(10), " ")

A1 is our line break text;
CHAR (10) is a line break (we discussed this a little higher in this article);
" " is a space, since we are changing the line break to a space

If you need to do the reverse operation - change the space to a hyphen (character), then the function will look like this:

SUBSTITUTE(A1, " ", CHAR(10))

I remind you that in order for line wrapping to be reflected correctly, it is necessary to specify “Wrap across lines” in the properties of the cells, in the “Alignment” section.

How to change hyphen to space and back in Excel using SEARCH - REPLACE

There are times when formulas are inconvenient to use and you need to make a replacement quickly. To do this, we use Find and Replace. Select our text and press CTRL + H, the following window will appear.

If we need to change the line break to a space, then in the "Find" line you need to enter a line break, for this stand in the "Find" field, then press the ALT key, without releasing it, type 010 on the keyboard - this is the line break code, it will not be visible in this field.

After that, in the "Replace with" field, enter a space or any other character you need to change to and click "Replace" or "Replace All".

By the way, in Word this is implemented more clearly.

If you need to change the line break character to a space, then in the "Find" field you need to specify special code"Line break", which is denoted as ^l
In the "Replace with:" field, you just need to make a space and click on "Replace" or "Replace All".

You can change not only line breaks, but also others Special symbols to get their corresponding code, you must click on the button "More >>", "Special" and select the code you need. I remind you that given function is only in Word, in Excel these characters will not work.

How to change line break to space or vice versa in Excel using VBA

Consider an example for selected cells. That is, we select the required cells and run the macro

1. Change spaces to hyphens in selected cells using VBA

Sub SpacesOn Hyphenation()
For Each Cell In Selection
cell.Value = Replace(cell.Value, Chr(32) , Chr(10) )
Next
end sub

2. Change hyphens to spaces in selected cells using VBA

Sub Carry onSpaces()
For Each Cell In Selection
cell.Value = Replace(cell.Value, Chr(10) , Chr(32) )
Next
end sub

The code is very simple Chr (10) is a line break, Chr (32) is a space. If you want to change to any other character, then simply replace the code number corresponding to the required character.

Character codes for Excel

The picture below shows various symbols and their corresponding codes, several columns are a different font. To enlarge the image, click on the picture.

Instruction

Most text entry and editing programs use the Enter key to move to the next line. If you need to go one term down, press the specified key once, if two (three, ten) - keep pressing the key until you go down to the desired line.

Line number in Microsoft editor Office Word can be seen in the status bar, which is located under the workspace. Right-click on it and select the “Line Number” item in the context menu with the left mouse button to track document statistics.

A regular line break does not always mark the beginning of a new paragraph, since a paragraph is usually indented. To mark a paragraph, press the Space key several times or set the desired options in the settings. To do this, select the desired piece of text and right-click on it.

In the context menu, select the "Paragraph" item - a new dialog box will open. Go to the "Indents and Spacing" tab in it and set the "Indent" value in the "First Line" field in the "Indent" group. If necessary, set your own indent width and click the OK button. The dialog box will close automatically and the settings will be applied to the selected text fragment.

To move to a new line in other applications, sometimes you need to use a keyboard shortcut. The Enter key remains the main key; the Ctrl, Shift or Alt keys can be used as an additional one. So, for example, a simple single press of the Enter key in an application Microsoft Office Excel will cause the cursor to move to the next cell. To continue entering text from a new line in one cell, use the combination of Alt and Enter.

In ICQ and QIP applications, everything depends on the selected settings. Sending a message can be done with the Enter key, then to go to a new line, use the combination of Ctrl and Enter. If sending text, on the contrary, is displayed on the designated keys, then the transition to a new line will be carried out by a single press of the Enter key.

Related videos

Sources:

• how to go to

Skills such as breaking a line or making a space are among the very basics of working in a text editor and on a computer in general. Without knowing them, it will simply be impossible for a novice user to move on to more serious writing and text formatting tools. This is practically the same as typing a document without knowing the keys.

You will need

• Mouse, keyboard
• text editor

Instruction

In order to move the line below, put the cursor in the place from which you plan to make this operation. You can move the cursor either with the mouse or with the arrows. Press the "Enter" key. The blinking cursor will be at the beginning of the next line. Together with it, the remaining one will be transferred to the line below.

If you periodically create documents in Microsoft program Excel, then noticed that all the data that is entered into the cell is written in one line. Since this may not always be suitable, and the option to stretch the cell is also not appropriate, it becomes necessary to wrap the text. The usual hitting "Enter" is not suitable, because the cursor immediately jumps to a new line, and what to do next?

In this article, we will learn how to transfer text in Excel to a new line within one cell. Let's see how this can be done in various ways.

Method 1

You can use the key combination "Alt + Enter" for this. Put italics before the word that should start on a new line, press "Alt", and without releasing it, click "Enter". Everything, italic or phrase will jump to a new line. Type all the text in this way, and then press "Enter".

The bottom cell will be selected, and the one we need will increase in height and the text in it will be fully visible.

To perform some actions faster, check out the list of hot keys in Excel.

Method 2

In order for italics to jump automatically to another line when typing words, when the text no longer fits in width, do the following. Select a cell and right-click on it. In the context menu, click "Format Cells".

At the top, select the "Alignment" tab and set the bird in front of the item "transfer by word". Click OK.

Write whatever you need, and if the next word does not fit in width, it will start on the next line.

If lines in the document should be wrapped in many cells, then first select them, and then check the box mentioned above.

Method 3

In some cases, everything that I talked about above may not work, because it is necessary that information from several cells be collected in one, and already divided into lines in it. So let's figure out which formulas to use to get the desired result.

One of them is CHAR() . Here, in brackets, you need to specify a value from one to 255. The number is taken from a special table that indicates which character it corresponds to. Code 10 is used to wrap the line.

Now about how to work with the formula. For example, let's take data from cells A1:D2 and do what is written in different columns (A, B, C, D) in separate lines.

I put italics in a new cell and write in the formula bar:

A1&A2&CHAR(10)&B1&B2&CHAR(10)&C1&C2&CHAR(10)&D1&D2

With the "&" sign, we link cells A1: A2 and so on. Press "Enter".

Do not be afraid of the result - everything will be written in one line. To fix this, open the "Format Cells" window and check the transfer box, as described above.

As a result, we get what we wanted. The information will be taken from the indicated cells, and where it was supplied in the CHAR (10) formula, a transfer will be made.

Method 4

To wrap text in a cell, another formula is used -. Let's take only the first line with the headings: Surname, Debt, Payable, Amount. Click on an empty cell and enter the formula:

CONCATENATE(A1,CHAR(10),B1,CHAR(10),C1,CHAR(10),D1)

Instead of A1, B1, C1, D1, specify the ones you need. Moreover, their number can be reduced or increased.

The result we get is this.

Therefore, we open the already familiar Format Cells window and mark the transfer point. Now the right words will start on new lines.

In the next cell, I entered the same formula, only indicated other cells: A2:D2.

The advantage of using this method, like the previous one, is that when the data in the original cells changes, the values ​​​​in these will also change.

In the example, the debt number has changed. If you also automatically calculate the amount in Excel, then you won’t have to change anything else manually.

Method 5

If you already have a document in which a lot is written in one cell, and you need to move the words, then we will use the formula.

Its essence is that we will replace all spaces with a line break character. Select an empty cell and add the formula to it:

SUBSTITUTE(A11;" ";CHAR(10))

Instead of A11 there will be your original text. Press the "Enter" button and immediately each word will be displayed on a new line.

By the way, in order not to constantly open the Format Cells window, you can use the special button "Move Text" located on the Home tab.

I think the described methods are enough to move italics to a new line in cell in Excel. Choose the one that suits the task best.

Not every user knows how to transfer the VKontakte line. Moreover, many do not even know about the existence of such a function. social network. The question of how to transfer text to Vkontakte often causes a number of difficulties for users. However, there are several ways to do this quickly and easily.

How to move a line in a Vkontakte message

This is the most common problem people face when sending messages. Sometimes a line break is simply necessary and the user, out of habit, presses the Enter key to move to a new line. But in this case, the message is instantly sent. To prevent this from happening, you must use the key combination Enter + Shift. This command will move the cursor to a new line.

You can do it differently. To do this, in the dialog box mode, hover over the "Submit" button. It is located to the right of the input field and is an icon in the form of a paper airplane. After that, a pop-up window will appear in which you can change the keyboard shortcuts for quick commands. By changing the parameter, the line break in the Vkontakte message will be carried out using the Enter key.

How to transfer the Vkontakte line in the status

Transferring the Vkontakte line in the status will be a little more difficult than in the message. In order for everything to work out, you need to follow a few simple steps:

1. Open your Vkontakte page;
2. In the field for entering the status, write any two words or letters;
3. Copy and paste the following code 　 in between;
4. Make sure there are spaces between the code and the words;
5. Click save and refresh the page;
6. You will see that the code itself is gone, instead of it there is an empty space;
7. Select and copy it;
8. Now erase all characters from the string and write the status you like;
9. Where necessary, paste the empty space that you copied earlier. Do this as many times as necessary;
10. Click Save. As a result, you will see that you have a status in several lines.

The simple methods discussed in this article allow you to wrap the VKontakte line in the text without much effort. This is very handy when sending large messages, especially those that use poems. A line break in the contact in the status will make the page more original.

There are many reasons why you might need to move to another line when typing a friend or leaving a comment. It could be a poem, or just a long test that needs to be made more readable without being split into two different messages. In Word and others text editors, we are used to doing this by simply pressing the enter key, but in a dialog box this leads to the immediate sending of the text to the interlocutor. Let's figure out how to make a line break in the dialog box and in the comments.

In the old design of VK, in the dialog box, when you hovered over the send arrow, it appeared context menu with two options to choose "send text when pressing Enter" or "send text when pressing Shift+Enter". Now this option has been removed, but you can do the demolition yourself.

Even if you often have to move to a new paragraph, you will quickly get used to pressing the desired keyboard shortcut when necessary.

This can be done a little differently when writing comments in VK. Here the developers left a choice.

1. Start writing the text until the moment of the necessary demolition.
2. Hover over the submit button.
3. A context menu will appear with a choice of keyboard shortcuts for sending text and line wrapping.

To start writing text from a new line, use either the same Shift+Enter or Ctrl+Enter. Choose the option that suits you best and use it. The settings will be saved and when you decide to write the next comment, press the selected keys to retreat down.

As you can see, everything is quite simple. If you use the mobile offer installed on your phone to exit VK, then you will not face such a problem, because on the touch keyboard, "Enter" is used by default for transfer (there are different variations interface, but usually this is the case), and to send a message, the VK arrow is earned.