Formating text in colums to copy to other applications

  • Thread starter Thread starter robertguy
  • Start date Start date
R

robertguy

Hi,

any help would be greatly received.

What I am trying to achieve is to format text in order for me to cu
and paste into other applications.

The text contains the item description in one column and the price i
another column, however when I highlight and copy then paste into th
application in work the columns are not formatted correctly and th
price column is all over the place.

e..g how I want it to look

price of item code 1234 (spanner) £63.00
price of item code 23 (hammer) £29.00
price of item code 9 (o/s) £26.13


e.g how it actually looks


price of item code 1234 (spanner) £63.00
price of item code 23 (hammer) £29.00
price of item code 9 (o/s) £26.13


It is worth noting that if I copy into notepad or word the formattin
is fine but not when I paste into the application in work (whic
appears to be a plain text editor)

Is there a way of formatting the text or putting in a dummy field ?


Ro
 
Rob

if it's a plain text editor, it's doing what it says on the tin ... plain
text editing. No formatting.

Perhaps you could tell us what it is called ? Note that in Outlook Express,
your before and after look the same ... no formatting.

Regards

Trevor
 
I think OE displays plain text in a proportional font (unless you've changed it
to (say) Courier New.

I see differences when I view it in Netscape Messenger 4.78 (using Courier New).
 
I think that a lot of applications will respect the tab character that excel
puts between cells when you copy it.

You could use a helper cell and do some nice concatenation:

=LEFT(A1&REPT(" ",40),40)&TEXT(B1,"£#,###,##0.00")

Then copy from this helper column.

And if you format that cell to use Courier New, you can see how it will align in
NotePad or OE (if you use a non-proportional font.)
 
Back
Top