asked on

Formatting to Notepad

Hi Experts,

I have one excel sheet in which I monitor my portfolio, after market hour I have to copy past to notepad but by doing so it is unorganized , I had Combine all thing by “&” but result is not satisfactory, anyone know how do I overcome from this mess?

See Attached.

Thanks
Format.xlsx
Format.txt

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Hello,

can you explain a bit more? Why do you need to combine with a & sign? If you copy a range of cells and paste it into Notepad, the cells will be separated by tab characters.

Is the attached file the desired result or does it illustrate the problem?

Naresh Patel

ASKER

I had done that thing too but it is still unorganized.

Thanks

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

I cannot help you if you don't answer my question for clarification.

David Johnson, CD

Are any of these more to your liking?
ee11jul13.d.docx
ee11jul13.txt
ee11jul13-via-wordpad.txt

Naresh Patel

ASKER

Is the attached file the desired result or does it illustrate the problem?

Yes it is the problem.

Thanks

Naresh Patel

ASKER

Mr. ve3ofa,

I can't see attached file as I am not in front of my desk.way back to home.defiantly go through and reply you soon.
Thanks

Paul Sauvé

If you use WordPad, rather than Notepad, you get this result:
Portfolio-Copy-to-WordPad.rtf

Naresh Patel

ASKER

Any one knwos how doi use =LEN function to over come this Problem

Thanks

Paul Sauvé

Could you please tell us what you want to do with the text file? Thanks.

ASKER CERTIFIED SOLUTION

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Naresh Patel

ASKER

That data want to past in yahoo messenger.
As it is not in aligned so that is why I have copy to notepad than do some alignment - then copy and past to yahoo messenger.

Thanks

Naresh Patel

ASKER

Thanks