| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text file copied
We have copied a text file from our mainframe and it has an ' in front of
each name, I tried going to data - convert text to columns and delimited but it is still there. Any idea? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text file copied
Try the Edit Replace feature, replacing the apostrophe with NOTHING, (just
leave that window blank)........ Vaya con Dios, Chuck, CABGx3 "Pammy" wrote: We have copied a text file from our mainframe and it has an ' in front of each name, I tried going to data - convert text to columns and delimited but it is still there. Any idea? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text file copied
I think I'd do that edit|replace while editing the text file--maybe using
NotePad??? Pammy wrote: We have copied a text file from our mainframe and it has an ' in front of each name, I tried going to data - convert text to columns and delimited but it is still there. Any idea? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copied Over My Previous MS Excel File | Excel Discussion (Misc queries) | |||
| How to Create a file in Excel that can't be copied or printed | Excel Worksheet Functions | |||
| Excel file 4MB.Copied sheets to a new file.Now=64Kb-easier way? | Excel Discussion (Misc queries) | |||
| How do I stop an Excel file from being copied | Excel Discussion (Misc queries) | |||
| Problems after user copied XLS file to different folder- Help | Excel Discussion (Misc queries) | |||
Linear Mode
