To get the row value in single line even though it is in 2 lines

  • 77 Views
  • Last Post 01 December 2017
Sunil Edupuganti posted this 29 November 2017

Hi,

I have a PO which contains several number of line items(Structure is same). So i made one layout and i am able to get the data from all the rows and i am exporting it in Excel. The problem here is, In some columns data is in 2 lines like, for suppose if we take MRP it is 1895.00. On PO it is printed as 1895 in one line and .00 in another line. So in Excel I am getting space for 1895 and .00. 

So, how could i get recognize this in a single line?? Because i want to remove that space in Excel??

Order By: Standard | Newest | Votes
Collins Sarmento posted this 29 November 2017

Hi Sunil, 

You could use an auto correct script to remove spaces thus making your field "1895.00" rather than "1895 .00". Let me know if this does not work or you need help with the script.

 

 

-Collins Sarmento

Sunil Edupuganti posted this 29 November 2017

Hi Collins,

Thanks for your reply, actually that is not the case for me..Kindly, check the attachment, So that you can understand my scenario.

I have tried what you said, but it's still having a space..

Attached Files

Sunil Edupuganti posted this 01 December 2017

Hey I found the solution..for this case

  • Liked by
  • Vladimir Dimitrijevic
Close