Skip to Content
0

How to display the concatenated column value separately in each cell of Microsoft Excel

Oct 20, 2016 at 08:18 AM

61

avatar image
Former Member

Hi There,

I am facing an issue while exporting the data (which is of concatenated columns) to Excel.

Currently I am having some data

for eg: 5/20/2016 8:46:42AM 5/20/2016 8:59:09AM 6/14/2016 11:26:02AM 6/15/2016 2:04:24PM 6/16/2016 3:58:18PM which sits in one cell of Excel while exporting.

I tried line break in my formula

whileprintingrecords; stringvar a1:=a1 + totext({IC3_ASSESSMENT.ASSESSMENT_END_DATE})+ " "

But still not working.

Note that out put should come as

cell1 cell2 cell 3 cell4 cell5

5/20/2016 5/20/2016 6/14/2016 6/15/2016 6/16/2016

8:46:42AM 8:59:09AM 11:26:02AM 2:04:24PM 3:58:18PM

Could you please suggest me any solution for getting this resolved

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Abhilash Kumar
Oct 20, 2016 at 10:09 AM
0

Hi Ginu,

You'd need a formula for each cell.

Formula for Cell 1 would be:

Split({string field}, ' ')[1]

Formula for Cell would be:

Split({string field}, ' ')[2]

And so on...

Place each formula beside each other so that it generates a new cell when exported to Excel.

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 20, 2016 at 02:08 PM
0

Hi Abhilash,

That didn't worked out.I have placed the new formulas adjacent to this formulae

whileprintingrecords; stringvar a1:=a1 + totext({IC3_ASSESSMENT.ASSESSMENT_END_DATE})+ " " in Group footer section.

--GS

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Oct 20, 2016 at 02:12 PM
0

What is the formula you used?

Does it display blank?

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 21, 2016 at 05:16 PM
0

I have used the formulae1

split(totext({IC3_ASSESSMENT.ASSESSMENT_END_DATE},","))[1].

It was the same way dispalyed all together in one cell.

But if we have so many records(concatenated data) do we need to write that much formulaes for sitting data in separate cell.Dont we have any dynamic ways to handle it?

Share
10 |10000 characters needed characters left characters exceeded