LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum brings back null Value RedDevil Excel Discussion (Misc queries) 2 April 2nd 07 11:47 AM
how do I remove leading spaces and leave the remianing spaces w Debi Excel Worksheet Functions 6 February 28th 07 03:29 PM
Editing e-mail address brings up Outlook in Excel cell HT New Users to Excel 2 September 23rd 05 04:34 PM
how to Import data in excel office2003 with data more 65000 rows Abhijit Excel Worksheet Functions 1 May 13th 05 05:12 AM
How do I set up excel so you enter a stock code and it brings up . kieronm Excel Discussion (Misc queries) 1 January 12th 05 11:01 AM


All times are GMT +1. The time now is 05:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"