Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm changing email programs and am trying to import client data. The old
program will allow me to export this data as csv only. The new program will import via csv or excel, but here's the problem: In the old program, the address info is separated by street address, city, state & zip. In the new program the data is one entry. I've been told I need to put two spaces between the data (in csv) in order for it to import correctly. Anyone know how to do this? Manual is not an option as there are 8800 entries. Any help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula to bring value from another sheet with different spaces | Excel Discussion (Misc queries) | |||
Inconsistant character spaces extraction formula | Excel Discussion (Misc queries) | |||
how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
how do I insert a variable amount of blank spaces in a formula? | Excel Worksheet Functions | |||
Formula to sort text values with spaces | Excel Discussion (Misc queries) |