Is There A Way To Fix This In A Report

rockyw

Well-known Member
Joined
Dec 26, 2010
Messages
1,196
Office Version
  1. 2010
Platform
  1. Windows
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
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
="2015270228 space in here "

Do you mean that literally, or is it:

="2015270228 "

or just a number held as tex with a trailing space?
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,212,141
Messages
6,106,197
Members
448,005
Latest member
Valvictor

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top