How to combine text from multiple cells?

[sierra]

How to combine text from many cells without writing each cell adress, just the scope of cells?
Can I combine tex from cells A1 to A3 in a faster way than writing a formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text from a really huge number of cells, like from B1 to B3489, and I want to do it without writing every cell adress.

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson

[Anne Troy]

If I were you, I'd consider saving the file as a text file, and opening in
Word and doing a find/replace. Even the =CONCATENATE function has a limit to
how many cells you can concatenate.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"sierra" <[email protected]> wrote in
message news:[email protected]...
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile:
http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>

[Duke Carey]

To concatenate the contents of 3,489 cells would overrun the limit on the
number of characters in a single cell.

Anne's suggestion is probably the most expedient. Copy your SINGLE COLUMN
of data into a new spreadsheet. Save the file as a tab-delimited text file.

Open it in Word and do a find & replace, searching for ^p (Word's
representation of an end of paragraph mark) and replacing it with a space.



"sierra" wrote:

>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088
>
>

[Dave Peterson]

J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:
>
> How to combine text from many cells without writing each cell adress,
> just the scope of cells?
> Can I combine tex from cells A1 to A3 in a faster way than writing a
> formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
> from a really huge number of cells, like from B1 to B3489, and I want
> to do it without writing every cell adress.
>
> --
> sierra
> ------------------------------------------------------------------------
> sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
> View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson