Pasting text from Access/SQL - word wrap problem

Hi

When I've copied data from an access or SQL table, and paste it into a new
excel 2003 document, it always wraps the text.

Is there a way to force it to paste normal (ie. non-wrapped) text?

Cheers
Grant

You can highlight the complete sheet by clicking the intersection of
the row and column identifiers, then Format | Cells | Alignment (tab)
and uncheck Wrap text - a few seconds' work.

Hope this helps.

Pete

This is what I'm currently having to do - over 10 to 20 times a day (ad hoc
spreadsheets are a major part of day to day work).

What I'm looking for is a setting in excel, or the new workbook template to
allow pasting text without wrapping. ie. without having to re-format after
pasting

Cheers
G


"Pete_UK" <pashurst@auditel.net> wrote in message
news:1140306301.709256.107590@g43g2000cwa.googlegroups.com...
> You can highlight the complete sheet by clicking the intersection of
> the row and column identifiers, then Format | Cells | Alignment (tab)
> and uncheck Wrap text - a few seconds' work.
>
> Hope this helps.
>
> Pete
>

Hi Grant

I don't have an Access or SQL table to test it on, but copying wrapped
text from one sheet to another in Excel, straight Paste leaves it
wrapped, but Paste Special>Values pastes it as unwrapped.

If that doesn't work, maybe recording a macro for the steps you now
take, and using that as you own "Paste Special" by adding to a button on
your Toolbar would help.

--
Regards

Roger Govier


"Grant Morgan" <grantmorgan@noemail.noemail> wrote in message
news:OgIpiQQNGHA.2828@TK2MSFTNGP12.phx.gbl...
> This is what I'm currently having to do - over 10 to 20 times a day
> (ad hoc spreadsheets are a major part of day to day work).
>
> What I'm looking for is a setting in excel, or the new workbook
> template to allow pasting text without wrapping. ie. without having to
> re-format after pasting
>
> Cheers
> G
>
>
> "Pete_UK" <pashurst@auditel.net> wrote in message
> news:1140306301.709256.107590@g43g2000cwa.googlegroups.com...
>> You can highlight the complete sheet by clicking the intersection of
>> the row and column identifiers, then Format | Cells | Alignment (tab)
>> and uncheck Wrap text - a few seconds' work.
>>
>> Hope this helps.
>>
>> Pete
>>
>
>

Thanks Roger - will give it a try


"Roger Govier" <roger@technologyNOSPAM4u.co.uk> wrote in message
news:%23wfoq0SNGHA.2788@TK2MSFTNGP11.phx.gbl...
> Hi Grant
>
> I don't have an Access or SQL table to test it on, but copying wrapped
> text from one sheet to another in Excel, straight Paste leaves it wrapped,
> but Paste Special>Values pastes it as unwrapped.
>
> If that doesn't work, maybe recording a macro for the steps you now take,
> and using that as you own "Paste Special" by adding to a button on your
> Toolbar would help.
>
> --
> Regards
>
> Roger Govier
>
>
> "Grant Morgan" <grantmorgan@noemail.noemail> wrote in message
> news:OgIpiQQNGHA.2828@TK2MSFTNGP12.phx.gbl...
>> This is what I'm currently having to do - over 10 to 20 times a day (ad
>> hoc spreadsheets are a major part of day to day work).
>>
>> What I'm looking for is a setting in excel, or the new workbook template
>> to allow pasting text without wrapping. ie. without having to re-format
>> after pasting
>>
>> Cheers
>> G
>>
>>
>> "Pete_UK" <pashurst@auditel.net> wrote in message
>> news:1140306301.709256.107590@g43g2000cwa.googlegroups.com...
>>> You can highlight the complete sheet by clicking the intersection of
>>> the row and column identifiers, then Format | Cells | Alignment (tab)
>>> and uncheck Wrap text - a few seconds' work.
>>>
>>> Hope this helps.
>>>
>>> Pete
>>>
>>
>>
>
>