Group:  Microsoft Excel ยป microsoft.public.excel.misc
Thread: Elimintae wierd charecters

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Elimintae wierd charecters
Max 25.09.2006 19:10:02
I have the following list, with spaces, charecters and numbers:

12345
54784 N01
121545 N02
..451452

How would I be able to pul the list in two columns? without any weird
charecters?

12345
54784 N01
121545 N02
451452


RE: Elimintae wierd charecters
Marcelo 25.09.2006 21:24:01
Hi Max,

what about,

replace "." by " " (no quotes)

and data | Text to column

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Max" escreveu:

[Quoted Text]
> I have the following list, with spaces, charecters and numbers:
>
> 12345
> 54784 N01
> 121545 N02
> .451452
>
> How would I be able to pul the list in two columns? without any weird
> charecters?
>
> 12345
> 54784 N01
> 121545 N02
> 451452
>
>

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net