Copy and pasting

[goldwhispers]

I am copying from a text file

update actualsavings
set datefrom = substring(datefrom,1,2) + '-' + substring(datefrom,4,2) + '-' + substring(datefrom,7,4)
from actualsavings

and i am trying to past it into one cell of excel, but it spreads it across a few cells, i have even tried to change the formatting of the cell to text and yet it still does it, anyone help..

ta

 

[VirtualTrainer]

If you need to wrap text in a single cell, move the insertion point to where you want the first part of the text to end, press Alt + Enter, and continue. So, if you want it to look exactly like this:

update actualsavings
set datefrom = substring(datefrom,1,2) + '-' + substring(datefrom,4,2) + '-' + substring(datefrom,7,4)
from actualsavings

Press Alt + Enter after "update actualsavings" and again after "substring(datefrom,7,4)"... or wherever you want to break it up.

This does what pressing Enter in Word would do - it takes you to a new line.

If I have misunderstood what you are trying to do, let me know.

Karyn


Karyn's Toolkit
Free Microsoft Office Tutorials

http://tutorials.esmartweb.com