ExcelBanter - add text to cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - add text to cell (https://www.excelbanter.com/excel-worksheet-functions/144669-add-text-cell.html)

user3307

add text to cell

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.

Mike H

add text to cell

Emma,

Try:-

=A1&"_"&B1

Mike

"user3307" wrote:

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.

joel

add text to cell

=CONCATENATE(A1,"_",TEXT(B1,"general"))

"user3307" wrote:

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.

user3307

add text to cell

thank you!

"Mike H" wrote:

Emma,

Try:-

=A1&"_"&B1

Mike

"user3307" wrote:

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.

All times are GMT +1. The time now is 12:47 PM.