F
filky
I am trying to convert a csv to a fixed length format using excel. Fo
example, if I have
22252,E,LAB01001
22253,E,LAB01002
and I use contatenate I can create a single cell containing this
22252 E LAB01001
22253 E LAB01002
However, if I have
225,E,LAB01001
22256,ER,LAB01001
and I know how long each field should be how do I consistently get
225 E LAB01001
22256 ER LAB01001
I wondered whether I could have a row of required cell lengths abov
the data and then concatenate the cells to a fixed length based on th
number entered but can't find a way of doing it. For example
14,7,8
225,E,LAB01001
22256,ER,LAB01001
I hope this is clear. Can anyone help
example, if I have
22252,E,LAB01001
22253,E,LAB01002
and I use contatenate I can create a single cell containing this
22252 E LAB01001
22253 E LAB01002
However, if I have
225,E,LAB01001
22256,ER,LAB01001
and I know how long each field should be how do I consistently get
225 E LAB01001
22256 ER LAB01001
I wondered whether I could have a row of required cell lengths abov
the data and then concatenate the cells to a fixed length based on th
number entered but can't find a way of doing it. For example
14,7,8
225,E,LAB01001
22256,ER,LAB01001
I hope this is clear. Can anyone help