Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exported from Access - text has a character before it
Hi I have just exported a databse to Excel
Some of the fields that are text have a character infront e.g. 'john how can I get rid of this character - manually is not an option - too many to do I tried find and replace for ' but that could not be found I also tried copy paste special value (as that worked on a different export - but not on thsi) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time/ Number format on excel file exported from Access | Excel Discussion (Misc queries) | |||
Some columns exported from Access do not sum | Excel Discussion (Misc queries) | |||
Need quotes around exported tab delimited text | Excel Discussion (Misc queries) | |||
Conditional Formatting not applied to data exported from Access | Excel Worksheet Functions | |||
why are there quotes in my exported text file? | Excel Discussion (Misc queries) |