Mapping Mulitple Elements to The Same Cell

  • Thread starter Thread starter CharlieBrown
  • Start date Start date
C

CharlieBrown

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?
 
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
 
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?
 
Back
Top