Hi Randy

in another column
=MID(A1,8,255) copy down as far as required.
Then, copy the new column and Paste SpecialValues to "fix "the data

Best try on a copy of your data to begin with - just in case!!!
--
Regards

Roger Govier


"Randy Bratton" wrote in
message ...
I need a formula that will delete the first seven characters in every
cell in
a column. Thanks
--
Randy Bratton