Elimintae wierd charecters

M

Max

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
 
M

Marcelo

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:
 
Top