We help IT Professionals succeed at work.

Export text object with space to Excel

jph826
jph826 asked
on
I have a report that has several blank text objects.  When I export to Excel, I need one space to show in each of these text objects.  I  know how to do this in Excel, but the report is going to be automated so I need the export to show the space in Excel.  Is there a formula for this?
Comment
Watch Question

Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Have you tried using a formula like

Space(1)

mlmcc

Author

Commented:
Perfect - thank you so much!