Joining Text in 2 Columns

  • Thread starter Thread starter inktec
  • Start date Start date
I

inktec

i have two columns with text in each. Say HP in column A, and 51645A i
Column B. I would like column C to read HP - 51645A. How do I joi
these two fields to do this, many thanks. Botswan
 
=a1&" - "&b1
i have two columns with text in each. Say HP in column A, and 51645A in
Column B. I would like column C to read HP - 51645A. How do I join
these two fields to do this, many thanks. Botswana
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Figuring out a lengthy formula. Probably quite simple... 3
MATCH OR VLOOKUP 3
Split column contents (de-concantenate) 7
why won't text-to-columns work here? 6
Macro for comparing columns and highlighting matching/differences 14
Text matching 3
In a sales quote sheet - sum totals by license type 1
Countif and Right functions 8

Back
Top