Forum Discussion
Suresh Bopparaju
Sep 27, 2017Copper Contributor
excel text editing issues
hello! Can anyone tell me how to insert a certain string at the begining of each cell? thanks!
Faysal Al Farooqui
Sep 27, 2017Copper Contributor
Way 1:
- Click the cell
- Press F2
- Press Home
- Then Type or Paste the string
Way2:
- Double Click on the begining point of a cell you want to add the string, and type or paste to add it.
Way3:
- Click the cell.
- Click on the begining point of that cell in Formula bar and start typing or paste your text to add it.
Suresh Bopparaju
Sep 27, 2017Copper Contributor
Thanks very much!
How can I do such insertions for a series of cells in one-shot?
- SergeiBaklanSep 27, 2017Diamond Contributor
If to do in-place you may use macro like
Sub AddTextToTheLeft() Dim rng As Range For Each rng In Selection rng.Value = "MyString" & rng.Value Next End Sub
or formula to concatenate your string with source cells in helper cells and after that paste them back as values to source cells