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

  • 44 Views
  • Last Post 2 weeks ago
Sunil Edupuganti posted this 2 weeks ago

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 2 weeks ago

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 2 weeks ago

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 2 weeks ago

Hey I found the solution..for this case

  • Liked by
  • Vladimir Dimitrijevic
Close