ExcelBanter - Elimintae wierd charecters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Elimintae wierd charecters (https://www.excelbanter.com/excel-discussion-misc-queries/111495-elimintae-wierd-charecters.html)

Max

Elimintae wierd charecters

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

Marcelo

Elimintae wierd charecters

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:

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

All times are GMT +1. The time now is 01:18 PM.