add text to cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do I add the text in column A to the number in column B?
example:
A1: Spain
B1: 1098
=> Spain_1098

Many thanks!
Emma.
 
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

SUMIF with criteria "<>" & "=" 4
Concantenate which keeps bold of some parts. 5
Networkdays and misleading results from blank column 3
Concatenate With Criteria 5
avoid nested IFs with another function 4
sumif - if the text has LCI in it 3
Counting within groups 1
Referencing text from another cell for criteria in functions 1

Back
Top