Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Formula to add spaces in csv

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Formula to add spaces in csv

Open the .CSV in notepad, then use the replace function to change commas to
spaces, or commas to commas plus a space, or whatever the final format has to
be.
Then import into Excel.

S


"Wet Nose" wrote:

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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Formula to add spaces in csv

I have a mac so no notepad. plan b?


"SatelliteMax" wrote:

Open the .CSV in notepad, then use the replace function to change commas to
spaces, or commas to commas plus a space, or whatever the final format has to
be.
Then import into Excel.

S


"Wet Nose" wrote:

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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default Formula to add spaces in csv

Do you have Word, or anything that edits documents on the Mac? Usually they
will all read and save as text.

"Wet Nose" wrote:

I have a mac so no notepad. plan b?


"SatelliteMax" wrote:

Open the .CSV in notepad, then use the replace function to change commas to
spaces, or commas to commas plus a space, or whatever the final format has to
be.
Then import into Excel.

S


"Wet Nose" wrote:

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.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Formula to add spaces in csv

TextEdit or SimpleText is on Macs

Wet Nose wrote:

I have a mac so no notepad. plan b?


"SatelliteMax" wrote:


Open the .CSV in notepad, then use the replace function to change commas to
spaces, or commas to commas plus a space, or whatever the final format has to
be.
Then import into Excel.

S


"Wet Nose" wrote:


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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula to bring value from another sheet with different spaces veena Excel Discussion (Misc queries) 6 July 11th 08 12:25 AM
Inconsistant character spaces extraction formula Sneilan Excel Discussion (Misc queries) 3 October 19th 07 04:54 PM
how do I remove leading spaces and leave the remianing spaces w Debi Excel Worksheet Functions 6 February 28th 07 04:29 PM
how do I insert a variable amount of blank spaces in a formula? Lucy4484 Excel Worksheet Functions 1 January 14th 07 11:36 PM
Formula to sort text values with spaces slim Excel Discussion (Misc queries) 4 May 19th 06 01:44 PM


All times are GMT +1. The time now is 12:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"