Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Listing Text From Separate Cells into One Cell
Dear all,
A workbook is forwarded to myself every month containing membership details for a club of which I am the secretary. In column A is a list of the e-mail addresses of the members, i.e. cells A1, A2, A3, A4... In order to copy the text into another programme I wish to list all of the addresses within one Excel cell. Is there a formula that I can use to do this? Any help would be much welcomed. Yours in appreciation, Neil |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Listing Text From Separate Cells into One Cell
Very easy with a "helper" column.
In B1 enter: =A1 In B2 enter: =B1 & CHAR(10) & A2 and copy down Format the last cell in column B with wrap on -- Gary''s Student - gsnu200804 "Neil Pearce" wrote: Dear all, A workbook is forwarded to myself every month containing membership details for a club of which I am the secretary. In column A is a list of the e-mail addresses of the members, i.e. cells A1, A2, A3, A4... In order to copy the text into another programme I wish to list all of the addresses within one Excel cell. Is there a formula that I can use to do this? Any help would be much welcomed. Yours in appreciation, Neil |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Listing Text From Separate Cells into One Cell
Hi Neil,
You can do a couple of things. Text to Date or use the concatenate formula. =CONCATENATE(O12," ",P12," ", Q12) O12 Jim P12 Gates Q12 Jim Gates I wanted spaces in between the First, Last and email components that is the reason for the "[space]" quotations. Before exporting your date to your external source you will need to highlight, copy and paste special values. Good luck! "Neil Pearce" wrote: Dear all, A workbook is forwarded to myself every month containing membership details for a club of which I am the secretary. In column A is a list of the e-mail addresses of the members, i.e. cells A1, A2, A3, A4... In order to copy the text into another programme I wish to list all of the addresses within one Excel cell. Is there a formula that I can use to do this? Any help would be much welcomed. Yours in appreciation, Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listing text within a cell | Excel Discussion (Misc queries) | |||
separate text from one cell into 3 or more cells | Excel Discussion (Misc queries) | |||
separate a text cell to many number cells | Excel Worksheet Functions | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) |