Assuming column A has the text values.
In B1 enter ="\" & A1
Double-click on fill handle of B1 to copy down.
Copy then paste special(in place)>values>OK>Esc.
Delete original column A if desired.
Or you could use a macro to do in place with no formulas.
Dim cell As Range
Dim moretext As String
Dim thisrng As Range
On Error GoTo endit
Set thisrng = Range(ActiveCell.Address & "," & Selection.Address) _
moretext = InputBox("Enter your Text")
For Each cell In thisrng
cell.Value = moretext & cell.Value
MsgBox "only formulas in range"
Gord Dibben MS Excel MVP
On Mon, 24 Sep 2007 17:40:55 -0700, "Bill Fuller" <email@example.com> wrote:
>I would like to prepend all text values in a column with "\". What is the
>easiest way to do this if there are thousands of rows?