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
Highlighted

Hi @karenbowenpooler1 

 

Does the attached file help?

 

 

Related Conversations
IF statements and conditional formatting
clare1981 in Excel on
1 Replies
Reverse numbers and characters in worksheet
David_Gerrior in Excel on
1 Replies
Sumifs
Jsbluemoon82 in Excel on
3 Replies
Excel formula similiar to texjoin
Carlo74 in Excel on
0 Replies
everything is black and white in excel
Gold4trees in Excel on
1 Replies
Deleting unwanted rows and columns
chipg900 in Excel on
4 Replies