Import Excel Data Brings Spaces

B

Brandon G.

When I import text data into brings in spaces following the
text...which doesn t allow me to center correctly. How do I
essentially cut off the spaces following the text. I try to use the
substitute fx but it removes the spaces between each work.

example

I_am_sam____

the underlines represent spaces

thanks in advance
BG
 
B

Brandon G.

When I import text data into brings in spaces following the
text...which doesn t allow me to center correctly. How do I
essentially cut off the spaces following the text. I try to use the
substitute fx but it removes the spaces between each work.

example

I_am_sam____

the underlines represent spaces

thanks in advance
BG
Click to expand...

thx so much

BG
 

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

Import Fixed Length Including Spaces 1
Removing excess spaces in data 7
Indent and fill color based on other columns data 1
When importing text field Excel chops off leading spaces 1
Can I use a formula to filter data? 8
Formula to add spaces in csv 4
Extracting spaces from a string of numbers 5
Import Excel data using ltrim 2

Top