Home

Excel formula?

%3CLINGO-SUB%20id%3D%22lingo-sub-1054278%22%20slang%3D%22en-US%22%3EExcel%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054278%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20that%20needs%20to%20be%20changed..there%20are%20nearly%204000%3C%2FP%3E%3CP%3Eit%20is%20listed%20as%20name%3Bemail%3B%20in%20each%20line.%26nbsp%3B%20what%20I%20need%20to%20do%20is%20format%20it%20as%20name%2Cemail%20in%20each%20line%2C%20so%20it%20will%20be%20CVS%20comma%20delimited%20to%20export%20into%20an%20email%20service....can%20anyone%20shed%20some%20light%20on%20this%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1054278%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055101%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055101%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481263%22%20target%3D%22_blank%22%3E%40karenbowenpooler1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDoes%20the%20attached%20file%20help%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
karenbowenpooler1
Occasional Visitor

I have a list that needs to be changed..there are nearly 4000

it is listed as name;email; in each line.  what I need to do is format it as name,email in each line, so it will be CVS comma delimited to export into an email service....can anyone shed some light on this please?

1 Reply

Hi @karenbowenpooler1 

 

Does the attached file help?

 

 

Related Conversations
How to count average in certain time range
rutilusss in Excel on
0 Replies
Subtotals or Vlookups or Both.
Kwesi_Quartey in Excel on
3 Replies
Excel for Mac - Point as separator in a German Excel
Mr_Geo91 in Excel on
3 Replies
Recovery & Solving the problem
Seve16640 in Excel on
0 Replies
Imported mdb tables not opened in the same Sheet
JozefMJ in Excel on
0 Replies