Add Text to the Beginning or End of a Cell in Google Sheets

Edited by Djinu, VisiHow, Anonymous, Eng and 2 others

You're watching VisiHow. In this video, we're going to show how to add text to the beginning or end of a cell using Google Sheets.

Add Text To Beginning Or End Of Cell In Google Spreadsheets.mp4-canvas58 702223.jpg

Ad

Steps

  1. 1
    Find data to modify.
    In this video, there is a list of keywords in column "B". Let's add "www." to the beginning and ".com" to the end of each of these keywords.
    Add Text To Beginning Or End Of Cell In Google Spreadsheets.mp4-canvas10 419672.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  2. 2
    Click the cell to store the modified data.
    Let's click cell "C2".
    Add Text To Beginning Or End Of Cell In Google Spreadsheets.mp4-canvas18 296281.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  3. 3
    Type "=concatenate("www.",B2,".com")" into cell "C2".
    Alternatively, you can click cell "B2" instead of typing "B2" in the formula.
    Add Text To Beginning Or End Of Cell In Google Spreadsheets.mp4-canvas40 496781.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    After the formula is correctly typed, press "Enter".
    "www." will be added to the beginning, and ".com" will be added to the end of the keyword.
    Add Text To Beginning Or End Of Cell In Google Spreadsheets.mp4-canvas54 830465.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    You can use this formula for the rest of the column "C" items.
    Simply double-click the lower right-hand corner of cell "C2".
    Add Text To Beginning Or End Of Cell In Google Spreadsheets.mp4-canvas57 785947.jpg
    Was this step helpful? Yes | No | I need help

    Advertisement

That was how to add text to the beginning and the end of a cell in Google Sheets. If you have any questions or comments, please leave them in the space below. Thanks for watching VisiHow!

Video: Add Text to the Beginning or End of a Cell in Google Sheets

Questions and Answers

Adding new data at the beginning of info in a cell with existing data?

I have existing data in cells and need to add data at the beginning of what is already in the cell. I have always done this in the past and today when I try to add new data in a cell it automatically highlights the first letter in the cell and erases everything already in the cell when I type new info.. I have tried: Just entering new data. I think it was caused by: No idea

Was this helpful? Yes | No | I need help

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

I am creating an inventory, I put in the inventory number into column A for all of these paintings but now my boss would like the year and a letter for Genre added to the end of the inventory numbers?

Ex. the inventory number is currently 981, I need to add "-84P" so that it reads 981-84P. I have a list of over 3000. paintings to do this with and was hoping I could select a range in column a and add -84P to all of the paintings from 1984 at once

Was this helpful? Yes | No | I need help

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

Append Text in the next line in same cell?

I have an excel tracker in which we made a cell as "Activity". . Day1: My team follow up with teams to provide work efforts and In the activity cell they mention as "@8/2/2016 - Sent request for assessment". . Day3: Team follow up again for work effort and they append details in the same in activity cell against that request "@8/5/2016 - Followed up with Team". . Day4: If work efforts are received they will continue with other activity and update the cell with "@8/6/2016 - Sent request to get quotes". . so all these updates should happen in the single row and in one particular cell we track activities with dates. Please advise what code should be applied in the vba.. I have tried: Private Sub CmdSubmit_Click()

Was this helpful? Yes | No | I need help

   'find nextrow in the data sheet
   nextrow = Worksheets("Data").Cells(Rows.Count, 1).End(xlUp).Row + 1
   'write the values from this form to excel row
   With Worksheets("Data")
       .Cells(nextrow, 1).Value = Me.TxtCRQ
       .Cells(nextrow, 2).Value = Me.LstRegion.Value
       .Cells(nextrow, 3).Value = Me.LstSite.Value
       .Cells(nextrow, 4).Value = Me.LstProgram.Value
       .Cells(nextrow, 5).Value = Me.LstSDM.Value
       .Cells(nextrow, 6).Value = Me.Activity
   End With. I think it was caused by: .Cells(nextrow, 6).Value = Me.Activity

In this cell I need to append latest activity details every time I do some activity on the request.

Was this helpful? Yes | No | I need help

VisiHow QnA. This section is not written yet. Want to join in? Click EDIT to write this answer.

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.




Djinu
Featured Author
365 Articles Started
403 Article Edits
21,200 Points
Djinu is a featured author with VisiHow. Djinu has achieved the level of "Lieutenant" with 21,200 points. Djinu has started 365 articles (including this one) and has also made 403 article edits. 97,000 people have read Djinu's article contributions.
Djinu's Message Board
Djinu: Hi, my name is Djinu.
Djinu: Can I help you with your problem about "Add Text to the Beginning or End of a Cell in Google Sheets"?
 

Article Info

Categories : Google

Recent edits by: tkahn, Eng, Anonymous

Share this Article:

Thanks to all authors for creating a page that has been read 554 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No