ExcelBanter - How to combine dat from 4 fields into one field

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

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

- - How to combine dat from 4 fields into one field (https://www.excelbanter.com/excel-worksheet-functions/28306-how-combine-dat-4-fields-into-one-field.html)

mdeanda

How to combine dat from 4 fields into one field

I have the follwing data in three fields

A1 A2 A3 A4
' Name '! Number

Desired Result
A1 A2 A3 A4 A5
' Name '! Number 'NAME'!NUMBER

Is their a function for this?

Peo Sjoblom

If you are looking to combine a string to return a cell address you need to
wrap it in INDIRECT

=A1&A2&A3&A4

use the ampersand to concatenate strings

--
Regards,

Peo Sjoblom

"mdeanda" wrote in message
...
I have the follwing data in three fields

A1 A2 A3 A4
' Name '! Number

Desired Result
A1 A2 A3 A4 A5
' Name '! Number 'NAME'!NUMBER

Is their a function for this?

jiwolf

enter into cell A5 "=A1&A2&A3"

"mdeanda" wrote in message
...
I have the follwing data in three fields

A1 A2 A3 A4
' Name '! Number

Desired Result
A1 A2 A3 A4 A5
' Name '! Number 'NAME'!NUMBER

Is their a function for this?

All times are GMT +1. The time now is 01:53 AM.