combine text from 2 cells HELP! PLEASE!

  • Thread starter Thread starter John Adams
  • Start date Start date
J

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).
 
One way:

=A1&"|"&B1

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

=A1&" | "&B1

HTH,

ryanb.
 
Back
Top