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
Assigning True and False values in IF statements
Blake_Begley in Excel on
2 Replies
Hyperlinks and Objects in Excel for shared files
Bluhe in Excel on
0 Replies
Conditional Highlighting for numbers within a text
bshfrd in Excel on
2 Replies
Clustered Column 2nd axis
Agriculture1880 in Excel on
0 Replies
Adding 2 numbers in a column with a comma in between
DonYTechGuy in Excel on
6 Replies