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)