Remove Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ddpcad - 24 Feb 2008 16:12 GMT

Hi All,
I've received an .xls file from a customer that contains a generous
amount of formatting. I use a 3rd party program to link spreadsheets to
AutoCAD drawing files (.dwg) but it chokes on this particular
spreadsheet I assume due to all of the formatting. Is there a way to
remove all formatting from a spreadsheet and maintain all of the data?
Dave
DDP

Reply to this Message

Nick Hodge - 24 Feb 2008 16:23 GMT

Dave

Open it and select all the data and then Edit>Clear>Formats

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk

> Hi All,
> I've received an .xls file from a customer that contains a generous amount
[quoted text clipped - 4 lines]
> Dave
> DDP

Reply to this Message

Dave Jones - 24 Feb 2008 20:21 GMT

> Dave
>
> Open it and select all the data and then Edit>Clear>Formats

thanks, that worked :)
Dave

Reply to this Message

Nick Hodge - 24 Feb 2008 21:01 GMT

Dave

Great, glad it worked

Signature

Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk

>> Dave
>>
>> Open it and select all the data and then Edit>Clear>Formats
>
> thanks, that worked :)
> Dave

Reply to this Message

Don Guillett - 24 Feb 2008 16:36 GMT

UN tested but try this
sub df()
Application.Cells.FormatConditions.Delete
end sub

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Hi All,
> I've received an .xls file from a customer that contains a generous amount
[quoted text clipped - 4 lines]
> Dave
> DDP

Reply to this Message