combine text from 2 cells HELP! PLEASE!

[John Adams]

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).

 

[ryanb.]

One way:

=A1&"|"&B1

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

=A1&" | "&B1

HTH,

ryanb.

 

[Chip Pearson]

John,

Try a formula like the following:

=A1&"|"&B1


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

 

[scotiajoe]

=CONCATENATE(a1,"|",b1

 

[John Adams]

=A1&"|"&B1