combine text from 2 cells HELP! PLEASE!

's Computer Specifications

I have text in cell A and Cell B. I would like to add the text in cell
B to the end of the text in cell A while seperating them with a |
(pipe).

's Computer Specifications

One way:

=A1&"|"&B1

or if you want spaces on both sides of the pipe:

=A1&" | "&B1

HTH,

ryanb.

"John Adams" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have text in cell A and Cell B. I would like to add the text in cell
> B to the end of the text in cell A while seperating them with a |
> (pipe).
>

's Computer Specifications

John,

Try a formula like the following:

=A1&"|"&B1

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"John Adams" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have text in cell A and Cell B. I would like to add the text in cell
> B to the end of the text in cell A while seperating them with a |
> (pipe).
>

's Computer Specifications

=CONCATENATE(a1,"|",b1

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

's Computer Specifications

On Tue, 25 Nov 2003 07:59:23 -0600, "Chip Pearson"
<(E-Mail Removed)> wrote:

>=A1&"|"&B1

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine Text Cells	lightbulb	Microsoft Excel Misc	3	24th Jul 2008 02:40 PM
Combine text and cells	=?Utf-8?B?SmVu?=	Microsoft Excel Misc	2	21st May 2007 08:48 PM
How can I combine text from several cells into one?	=?Utf-8?B?TWljaGFlbA==?=	Microsoft Excel Misc	3	16th Jan 2007 10:25 PM
How to combine 2 cells' text into 1 cell	athatisme4@gmail.com	Microsoft Excel Misc	1	12th Oct 2005 12:54 AM
How to combine text of two cells	David Lewis	Microsoft Excel Misc	5	24th Oct 2003 12:04 AM