Elimintae wierd charecters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wildcard Usage: I absolutely need this to count?/sum? two or more criteri 2
HOW TO ZERO FILL A CELL THAT CONTAINS OTHER DATA EX. 000123? 7
Make the charecters in a cell to equal a certain quanity 2
Cell value equals last four charecters 2
Urgent help from all excel expert ! 4
Hi Just want to find out if regular expression is possible. 1
how do i truncate text-- create cell with only 125 charecters 2
go through numbered records 3

Back
Top