Removing apostrophe from imported data

[Rita Palazzi]

Windows XP Professional
Office 2000


I've got text in an imported column. There is an apostrophe at the
beginning of every cell. Is there a quick easy way to remove the
apostrophe from all cells?

Thanks in advance for any help!

Rita Palazzi
Senior Engineer / Global Trade Services
FedEx Express

 

[keepITcool]

try:

Sub foo()
With Range("a:a")
.Formula = .Value
End With
End Sub




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rita Palazzi wrote :