Add character before 1st letter of string
 

How can I add character e.g: ' before 1st letter of words in selected
cells (multiple selection).
Can anybody help pls ( as I would like to convert some numbers into
text format)
Thxs

Add character before 1st letter of string
 

Hello al007,

Here's how...

Code
-------------------

Sub Test()

Dim Rng As Range

Set Rng = Application.Selection

For Each Cell In Rng
Cell.Value = "'" & Cell.Value
Next Cell

End Sub

-------------------


Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=49537