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

Edited by Djinu, VisiHow, Eng, tkahn and 1 other

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.

Adding text automatically to the end of a string of text?

I would like to have the formula inserted into blank cells and when some types in them it adds in parenthesis a single number to the end of the text string that the user just entered. It only tells me how to insert to the beginning or end of an existing cell

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.

Referencing this Article

If you need to reference this article in your work, you can copy-paste the following depending on your required format:

APA (American Psychological Association)
Add Text to the Beginning or End of a Cell in Google Sheets. (2017). In VisiHow. Retrieved Mar 28, 2017, from http://visihow.com/Add_Text_to_the_Beginning_or_End_of_a_Cell_in_Google_Sheets

Was this helpful? Yes | No | I need help

MLA (Modern Language Association) "Add Text to the Beginning or End of a Cell in Google Sheets." VisiHow, visihow.com/Add_Text_to_the_Beginning_or_End_of_a_Cell_in_Google_Sheets Accessed 28 Mar 2017.

Was this helpful? Yes | No | I need help

Chicago / Turabian VisiHow.com. "Add Text to the Beginning or End of a Cell in Google Sheets." Accessed Mar 28, 2017. http://visihow.com/Add_Text_to_the_Beginning_or_End_of_a_Cell_in_Google_Sheets.

Was this helpful? Yes | No | I need help

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments

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

Ask the author

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. 118,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, VisiHow

Share this Article:

Thanks to all authors for creating a page that has been read 729 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