Forum Discussion
excel text editing issues
hello!
Can anyone tell me how to insert a certain string at the begining of each cell?
thanks!
3 Replies
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.
Thanks very much!
How can I do such insertions for a series of cells in one-shot?
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
