Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Joining text in one cell
hi all of you i want to join text values given in various cells into one cell. for example i have data as follows Row 1 Ankit Row 2 Garg Row 3 Chartered Row 4 Accountant Row 4 Delhi Row 5 India and the desired result is as follows Row 6 Ankit Garg Chartered Accountant Delhi India also if i want to insert any comma or semicolon between these text values like Row 6 Ankit, Garg, Chartered, Accountant, Delhi, India, kindly suggest any method or formula for this thanks in advance Ankit Garg India |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Joining text in one cell
Hi
A rather long-winded formula: =A1&A2&A3&A4&A5 if you want commas or other delimiters (such as spaces) then: =A1 & "," & A2 & "," & A3 & "," & A4 & "," & A5 Hope this helps! Richard ca.ankitgarg wrote: hi all of you i want to join text values given in various cells into one cell. for example i have data as follows Row 1 Ankit Row 2 Garg Row 3 Chartered Row 4 Accountant Row 4 Delhi Row 5 India and the desired result is as follows Row 6 Ankit Garg Chartered Accountant Delhi India also if i want to insert any comma or semicolon between these text values like Row 6 Ankit, Garg, Chartered, Accountant, Delhi, India, kindly suggest any method or formula for this thanks in advance Ankit Garg India |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Joining text in one cell
On 19 Jan 2007 04:19:42 -0800, "ca.ankitgarg" wrote:
hi all of you i want to join text values given in various cells into one cell. for example i have data as follows Row 1 Ankit Row 2 Garg Row 3 Chartered Row 4 Accountant Row 4 Delhi Row 5 India and the desired result is as follows Row 6 Ankit Garg Chartered Accountant Delhi India also if i want to insert any comma or semicolon between these text values like Row 6 Ankit, Garg, Chartered, Accountant, Delhi, India, kindly suggest any method or formula for this thanks in advance Ankit Garg India In addition to the formula posted, you could download and install Longre's free morefunc.xll add-in from: Then use the formula: =MCONCAT(A1:A6," ") or, with <comma<space: =MCONCAT(A1:A6,", ") --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Joining text in one cell
Try
=A1&", "&A2&", "&A3&", "&A4&", "&A5 "ca.ankitgarg" wrote: hi all of you i want to join text values given in various cells into one cell. for example i have data as follows Row 1 Ankit Row 2 Garg Row 3 Chartered Row 4 Accountant Row 4 Delhi Row 5 India and the desired result is as follows Row 6 Ankit Garg Chartered Accountant Delhi India also if i want to insert any comma or semicolon between these text values like Row 6 Ankit, Garg, Chartered, Accountant, Delhi, India, kindly suggest any method or formula for this thanks in advance Ankit Garg India |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Joining text in one cell
=concatenate(a1,a2,a3) add as required
"ca.ankitgarg" wrote: hi all of you i want to join text values given in various cells into one cell. for example i have data as follows Row 1 Ankit Row 2 Garg Row 3 Chartered Row 4 Accountant Row 4 Delhi Row 5 India and the desired result is as follows Row 6 Ankit Garg Chartered Accountant Delhi India also if i want to insert any comma or semicolon between these text values like Row 6 Ankit, Garg, Chartered, Accountant, Delhi, India, kindly suggest any method or formula for this thanks in advance Ankit Garg India |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Joining text in one cell
thanks to all of you for the support u provided.
thanks again. bye |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aligning Wraped Text to the bottom of a cell | Excel Discussion (Misc queries) | |||
Cell Capacity - text | Excel Discussion (Misc queries) | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions |