Skip to main content
added 112 characters in body
Source Link
Sergio
  • 608
  • 6
  • 15

Edit 1: With the image provided, it's not possible to make it as you want. Please, read my last comment.

Well, you could create calculated columns in your list. These calculated columns would get data from each column, so, using this formula:

=MID([Method], FIND(">", [Method], 1)-1, FIND("<", [Method], 1)-1)

In this way, you could get the text between tags, because MID function combined with FIND could get the text between tags. In that example you would get the text from <Method> tag.

So, once you have the correct text en each calculated column, you can create a view in that list with these calculated columns, and when you export you will see the correct columns in the Excel.

Resources:

Well, you could create calculated columns in your list. These calculated columns would get data from each column, so, using this formula:

=MID([Method], FIND(">", [Method], 1)-1, FIND("<", [Method], 1)-1)

In this way, you could get the text between tags, because MID function combined with FIND could get the text between tags. In that example you would get the text from <Method> tag.

So, once you have the correct text en each calculated column, you can create a view in that list with these calculated columns, and when you export you will see the correct columns in the Excel.

Resources:

Edit 1: With the image provided, it's not possible to make it as you want. Please, read my last comment.

Well, you could create calculated columns in your list. These calculated columns would get data from each column, so, using this formula:

=MID([Method], FIND(">", [Method], 1)-1, FIND("<", [Method], 1)-1)

In this way, you could get the text between tags, because MID function combined with FIND could get the text between tags. In that example you would get the text from <Method> tag.

So, once you have the correct text en each calculated column, you can create a view in that list with these calculated columns, and when you export you will see the correct columns in the Excel.

Resources:

added 4 characters in body
Source Link
Sergio
  • 608
  • 6
  • 15

Well, you could create calculated columns in your list. These calculated columns would get data from eac XMLeach column, so, using this formula:

=MID([Method], FIND(">", [Method], 1)-1, FIND("<", [Method], 1)-1)

In this way, you could get the text between tags, because MID function combined with FIND could get the text between tags. In that example you would get the text from <Method> tag.

So, once you have the correct text en each calculated column, you can create a view in that list with these calculated columns, and when you export you will see the correct columns in the Excel.

Resources:

Well, you could create calculated columns in your list. These calculated columns would data from eac XML column, so, using this formula:

=MID([Method], FIND(">", [Method], 1)-1, FIND("<", [Method], 1)-1)

In this way, you could get the text between tags, because MID function combined with FIND could get the text between tags. In that example you would get the text from <Method> tag.

So, once you have the correct text en each calculated column, you can create a view in that list with these calculated columns, and when you export you will see the correct columns in the Excel.

Well, you could create calculated columns in your list. These calculated columns would get data from each column, so, using this formula:

=MID([Method], FIND(">", [Method], 1)-1, FIND("<", [Method], 1)-1)

In this way, you could get the text between tags, because MID function combined with FIND could get the text between tags. In that example you would get the text from <Method> tag.

So, once you have the correct text en each calculated column, you can create a view in that list with these calculated columns, and when you export you will see the correct columns in the Excel.

Resources:

Source Link
Sergio
  • 608
  • 6
  • 15

Well, you could create calculated columns in your list. These calculated columns would data from eac XML column, so, using this formula:

=MID([Method], FIND(">", [Method], 1)-1, FIND("<", [Method], 1)-1)

In this way, you could get the text between tags, because MID function combined with FIND could get the text between tags. In that example you would get the text from <Method> tag.

So, once you have the correct text en each calculated column, you can create a view in that list with these calculated columns, and when you export you will see the correct columns in the Excel.