| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Speech Marks in a table field
I was wondering if anyone could help me?
I have in my database fields that sometimes pull over with speech marks at the beginning and end of each field. For example, the field will show "9590" or "12345$12" Would I use an IIf statement combined with a Trim statement? If yes, what would be an example of what to put? If no, what should I do? Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing entry from pivot table field list in Excel 2000 | Excel Discussion (Misc queries) | |||
| removing " marks from imported email addresses | Excel Discussion (Misc queries) | |||
| Why does a sumif use double speech marks | Excel Discussion (Misc queries) | |||
| removing character from field | Excel Worksheet Functions | |||
| Removing the : in the coment field | Excel Discussion (Misc queries) | |||
Linear Mode
