Is There A Way To Fix This In A Report

[rockyw]

I have several reports that some columns of numbers have this (="2015270228 space in here ") so the numbers do not a center in the column. Is there any way to fix this quick and easy? I didn't make the report, it comes from a differant program and is exported to Excel. Thanks

 

[PaddyD]

="2015270228 space in here "

Do you mean that literally, or is it:

="2015270228 "

or just a number held as tex with a trailing space?

 

[rockyw]

There is a long space between the number and the trailing ", this makes the number go far left in the column. When I tried to post the exact way it looks but it would not show that way. Thanks for the reply.

 

[rob.barnes01]

Try the TRIM function: =TRIM(cellreference). That should remove the extra spaces.

 

[rockyw]

WOW, yes that works. I can insert an extra column, trim the spaces out and then hide the old column. Thanks and have a great week.