# Function does not work with Import data from Excel

**URL:** <https://community.wolfram.com/t/function-does-not-work-with-import-data-from-excel/5484>\
**Category:** Questions\
**Created:** [April 21, 2015, 9:06am UTC](https://community.wolfram.com/t/function-does-not-work-with-import-data-from-excel/5484 "2015-04-21T09:06:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![aajgeeraert](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@aajgeeraert](https://community.wolfram.com/u/aajgeeraert)\
**Post date:** [April 21, 2015, 9:06am UTC](https://community.wolfram.com/t/function-does-not-work-with-import-data-from-excel/5484/1 "2015-04-21T09:06:05Z")

</div>

I am busy studying a Mathematica book (from Paul Welling)  
I have a formula from his book and I want to apply it to imported data from Excel. Stuck, just refuses to work on the imported data ?  
I tried some things but to no avail ? What could be the problem ?

---

<div class="post-metadata">

**Author:** ![aajgeeraert](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@aajgeeraert](https://community.wolfram.com/u/aajgeeraert)\
**Post date:** [April 21, 2015, 9:26am UTC](https://community.wolfram.com/t/function-does-not-work-with-import-data-from-excel/5484/2 "2015-04-21T09:26:51Z")

</div>

I saw too late that I made a typing error in the example : should be "UndirectedEdge"and not “UnDirectedEdge”. But it still doesn’t work.

Thank you for your time  
Chiel Geeraert

---

<div class="post-metadata">

**Author:** ![aajgeeraert](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@aajgeeraert](https://community.wolfram.com/u/aajgeeraert)\
**Post date:** [April 21, 2015, 9:36am UTC](https://community.wolfram.com/t/function-does-not-work-with-import-data-from-excel/5484/3 "2015-04-21T09:36:28Z")

</div>

Just writing helps a lot ! I think I overlooked the problem. With the import from Excel quotes are added , so instead of {{ John, Peter}} I get {{“John,Peter”}}. I have to get rid of the quotes ? Any idea ?  
Thank you

---

<div class="post-metadata">

**Author:** ![suvadipmandal31](https://yyz1.discourse-cdn.com/wolfram/user_avatar/community.wolfram.com/suvadipmandal31/32/17402_2.png) [@suvadipmandal31](https://community.wolfram.com/u/suvadipmandal31)\
**Post date:** [April 21, 2015, 10:05am UTC](https://community.wolfram.com/t/function-does-not-work-with-import-data-from-excel/5484/4 "2015-04-21T10:05:33Z")

</div>

Can you upload the fbook\_import2.xlsx file?

---

<div class="post-metadata">

**Author:** ![aajgeeraert](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@aajgeeraert](https://community.wolfram.com/u/aajgeeraert)\
**Post date:** [April 21, 2015, 10:23am UTC](https://community.wolfram.com/t/function-does-not-work-with-import-data-from-excel/5484/5 "2015-04-21T10:23:33Z")

</div>

Well , after a few hours of trying the problem is solved. I didn’t set up correctly in Excel.  
I had a list of two columns of names which I want to combine with ‘UndirectedEdges’ In Excel I already concatened the strings and imported them in Mathematica. But what I overlooked is that Mathematica sees the concatenation as one string and not as two separate string.  
So I splitted the names over two colums and now the import works as expected.

Thank you for your time,  
Chiel Geeraert