Excel Help
 

I have a column of data I want to use Text to columns to fix.
The data is not lined up in every cell.

3 MSW
3 MC5000
3 Clm10000
3 STR

When I get rid of the first column of numbers, there is an extra space on the left in many cells.
I tried using TRIM but it doesn't work.

Any suggestions?

TY

Try

=SPLIT(A?," ")

Try using the Text to Columns function:

Either delimited by space or use Fixed width (importing only the column you want).

I'm using Text to Columns, but I still get the text off set.
The example I used straightened itself out in my post!
Looks like this:

3 MSW
3... MC5000
3 Clm10000
3 ...STR

Then after T2C it looks like this

MSW
... MC5000
Clm10000
...STR

I get a function not valid comment.

Try this.

Highlight entire row first. Then do text to columns. Choose delimit by space.

Are you taking the data from DRF Winner's books?

I am merging several old Excel sheets into one so I can put into Access.
Some of the data came from comma files, and were spaced odd.

I'll try that T2C method.
I've been using fixed.

Just tried - nope - splits in to too many columns - like, Md Sp Wt is not 3 columns.

I have a manual workaround, just takes a long time.

TY

Shouldn't be any issues if imported from previous xls but try using the CLEAN function to strip out any funky data that may be present before you go T to C.

Clean as no effect.

I tried your posted example and it works for me




Did you click the check box on screen two of the splitter "treat consecutive delimiters as one"




If thats not it, upload a sample file, and Ill look at it

=SUBSTITUTE(RIGHT(A1,LEN(A1)-1)," ","")

Where the initial data is in A1.

Could you use find and replace? In the find box hit the space bar, in the replace box put nothing. replace all. done.

CJ - will try that.
Suff - tried that - no luck.
Alton-
I'm using Excel 2000, so maybe some of those things weren't around back then.

If you would like to send me some of the data, I would give it a whirl and try to help. I'm using Excel 2003.



Just a thought..........

Cool, let me know. Possible the white space is tab or something else if that doesn't work. I just replaced your dots in the example with spaces.