Hi,
I received an excel sheet with about three hundred records. All the information is stored in one cell with three lines of text in each row. The first row contains the First & Last Name, Second Row is Telephone number, and third is Fax Number. When I used the Delimited Function it does not identify the second and third row of the cell, but just the first. When I use the fixed option it is impossible to include all the records without cutting off a name or part of a telephone number in the process.
Is there a better way to separate text in cell (with three lines of text in each cell) into multiple fields? Any help would be greatly appreciated.
Bookmarks