Import Excel Data Brings Spaces
 

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

Import Excel Data Brings Spaces
 

Hi

Trim will remove leading/traling spaces

=TRIM(A1)

Mike

"Brandon G." wrote:

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

Import Excel Data Brings Spaces
 

On Dec 10, 7:34 am, "Brandon G." wrote:
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

thx so much

BG