Forum Discussion

Copper Contributor

Sep 27, 2017

excel text editing issues

hello! Can anyone tell me how to insert a certain string at the begining of each cell? thanks!

Copper Contributor

Sep 27, 2017

Thanks very much!

How can I do such insertions for a series of cells in one-shot?

Diamond Contributor

Sep 27, 2017

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