Mapping Mulitple Elements to The Same Cell
 

I have an InfoPath form with multiple text control boxes whose content I
would like to import into the same cell of an Excel spreadsheet. Is there a
way to map elements into the same cell so I can import the InfoPath data
automatically?

Mapping Mulitple Elements to The Same Cell
 

Hi
A cell has one value property, so you cannot import distinct text
strings. You could concatenate each of the text strings to produce one
long string

MyString = TextBox1.Value
MyString = MyString & TextBox2.Value
etc

You can add other text elements too

MyString = TextBox1.Value
MyString = "/" & MyString & TextBox2.Value

to make a meaningful string.

regards
Paul

On Oct 16, 7:20*am, CharlieBrown
wrote:
I have an InfoPath form with multiple text control boxes whose content I
would like to import into the same cell of an Excel spreadsheet. *Is there a
way to map elements into the same cell so I can import the InfoPath data
automatically?

Mapping Mulitple Elements to The Same Cell
 

Paul:
I am not a programmer, but use Excel functions extensively, and now
InfoPath. Where would I key the information in your message below? Are
those arguments in MS Excel Concatenate function?

" wrote:

Hi
A cell has one value property, so you cannot import distinct text
strings. You could concatenate each of the text strings to produce one
long string

MyString = TextBox1.Value
MyString = MyString & TextBox2.Value
etc

You can add other text elements too

MyString = TextBox1.Value
MyString = "/" & MyString & TextBox2.Value

to make a meaningful string.

regards
Paul

On Oct 16, 7:20 am, CharlieBrown
wrote:
I have an InfoPath form with multiple text control boxes whose content I
would like to import into the same cell of an Excel spreadsheet. Is there a
way to map elements into the same cell so I can import the InfoPath data
automatically?