| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i truncate text-- create cell with only 125 charecters | Excel Worksheet Functions | |||
| Wierd Save problem | Excel Discussion (Misc queries) | |||
| Cell value equals last four charecters | Excel Discussion (Misc queries) | |||
| Convert lower case charecters to upper case | Excel Discussion (Misc queries) | |||
| Small font on row & column numbers - wierd | Excel Discussion (Misc queries) | |||
Linear Mode
