Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles Add text in Excel How to Add text in Excel – Excelchat

How to Add text in Excel – Excelchat

With the Excel add text to cell operation, we can easily input text to a range of selected cells in our worktable. Easily add a string, prefix, a suffix, or any other characters we need within our selected cell range.

Figure 1. of Add Text in Excel

Sometimes we may need to enter text in Excel or specific text at the beginning or at the end of some cells in our spreadsheet selection. Excel also allows us to specify the exact location for the input. If we were to input the text manually into each cell, it would be time-consuming.

How to Add Text to a Cell in Excel

We can easily insert text into Excel by using the ampersand (&) formula.

We will now demonstrate how to use Excel insert text via formula in the following simple steps;

  1. Enter the text/data values into our worksheet;

Figure 2. of Text Values in Excel

Our purpose in the illustration above, is to add text to cells in column A by using the & formula.

We want our specified text to appear before the text value in each cell in column A.

  1. The & formula we will enter into cell C2 above is as follows:
    =“ENTER:”&A2

Figure 3. of Add Text in Excel

The result is the text “ENTER” – which we specified in our formula for adding text in Excel – before the text in cell A2.

  1. Modify and copy the & formula in cell C2 above down into the other cells in the column for similar outcomes;

Figure 4. of Add Text in Excel

We can also modify the & formula to add text to the end of a cell

Entering the formula =A6&”ENTER” will add “ENTER” at the end of the text in the cells:

Figure 5. Add Text in Excel

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc