Removing apostrophe from imported data

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

try:

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




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


Rita Palazzi wrote :

> 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