AndyPandy
asked on
Excel, parse strings into columns from a list of offsets (columns widths) and column names
How to parse strings into columns from a list of offsets (columns widths) and column names. The rows of text are limited to a hundred or so. The source string length is <1000 characters, there are about 40 columns of vary widths.
EE-Excel-parse.xls
EE-Excel-parse.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
AndyPandy,
Glad to help, and not surprised that once again barry wins the formula derby :)
One of the functions I used, IFERROR, debuted in Excel 2007, so yes, in Excel 2003 and earlier you will get a #NAME error if you use it.
Patrick
Glad to help, and not surprised that once again barry wins the formula derby :)
One of the functions I used, IFERROR, debuted in Excel 2007, so yes, in Excel 2003 and earlier you will get a #NAME error if you use it.
Patrick
ASKER
Thomas, nice but leaves #value when string too short.
Matt, #Name?, perhaps my Excel 2003 doesn't support your solution?
Barry, Nice short and sweet and no error. Still trying to figure out how it does this.
Thanks guys!