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
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies
Help with minutes/seconds to seconds.
SteveMorley in Excel on
1 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies