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
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
Goal seek
Abui_2195 in Excel on
0 Replies
Preparing a stacked chart
EuroSree in Excel on
0 Replies
Please Help debug my matrix formula
Katharina_Stemmer1989 in Excel on
0 Replies
Linking external source (eg Share Price) to a cell
Aitch1964 in Excel on
0 Replies
Insert an image in Excel header
mat74 in Excel on
1 Replies
DAX Powerpivot - How to solve this problem in PowerPivot
kayyeah11 in Excel on
0 Replies