Left Justified information in Column

  • Thread starter Thread starter John
  • Start date Start date
J

John

Some of my columns are coming in with spaces in front of
the data. Is there a way to left justify a column so that
it gets rid of the spaces and starts with information.

Thanks,
JOhn
 
John said:
Some of my columns are coming in with spaces in front of
the data. Is there a way to left justify a column so that
it gets rid of the spaces and starts with information.

Thanks,
JOhn
Click to expand...

John,

Try:

Trim(<your-expression>)


Sincerely,

Chris O.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Contenate & Right Justify 2
Right Justify text 3
How do I remove leading spaces the column is left justified 3
space between columns 4
Union query returns date as Text which doesn't sort correctly 1
Combine two cells without losing data cell formats 2
How to right justify text in a listbox column. 6
Dollar sign left justified - data right justified - large space 3

Back
Top