MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Importing Text Field with Delimiter in Text - Concatenation?

Posted by Brian P on June 06, 2001 9:54 AM

When I import data into excel, one of the text fields (column) has tabs (the delimiter) in the text. When I import it all of the other data goes into the columns in excel fine but this text field ends up in many columns – could be 30 columns. I usually move this field to the last field and use concatenate to create a single field. Is there a better way to do this? I get tired of concatenating so many fields. When I use concatenate – I do something like concatenate(b1,c1,d1,e1,f1)


Posted by Ron on June 06, 2001 10:12 AM

If the data is of similar width in each field, you could choose the fixed width file type and adjust the columns and place the breaks where you wish. Just a thought.

Posted by brian p on June 06, 2001 10:16 AM

I can't use fixed width. I also tried importing twice. Once with all data and the second time selecting do not import all columns except for the last - wish I could use delimiters for all columns except the last and use fixed width on it.
Any other ideas?

Posted by Barrie Davidson on June 06, 2001 11:52 AM

Can you change the delimiter in your source file?

Posted by Brian P on June 06, 2001 5:21 PM

It took me awhile but I figured out a way change the delimiter (not to one of my choice unfortunately) It imports negative number incorrectly - with the minus sign on the right -and spaces on the left so excel thinks its text...but thats easy to fix. Thanks guys!