dversloot1
Board Regular
- Joined
- Apr 3, 2013
- Messages
- 113
Hello,
I'm attempting to format a string of data in excel cleanly so that it looks presentable in an email.
I have a variety cells with different character lengths. I'm trying to string together Fields 1 through 4 in the desired format below; proper spacing between each field.
[TABLE="width: 532"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Desired Format[/TD]
[TD]Field 1[/TD]
[TD]Field 2[/TD]
[TD]Field 3[/TD]
[TD]Field 4[/TD]
[/TR]
[TR]
[TD]DMR 65 58% ABC[/TD]
[TD]DMR[/TD]
[TD]65[/TD]
[TD]58%[/TD]
[TD]ABC[/TD]
[/TR]
[TR]
[TD]VA 58 4% DEF[/TD]
[TD]VA[/TD]
[TD]58[/TD]
[TD]4%[/TD]
[TD]DEF[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
How can this be done?
Not sure if the table will show what I am trying to achieve. I would like field 2 to start 8 characters in from the beginning of the string, the 3rd field at 16 characters, and the 4th field at 24 characters in...
thanks,
Dan
I'm attempting to format a string of data in excel cleanly so that it looks presentable in an email.
I have a variety cells with different character lengths. I'm trying to string together Fields 1 through 4 in the desired format below; proper spacing between each field.
[TABLE="width: 532"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Desired Format[/TD]
[TD]Field 1[/TD]
[TD]Field 2[/TD]
[TD]Field 3[/TD]
[TD]Field 4[/TD]
[/TR]
[TR]
[TD]DMR 65 58% ABC[/TD]
[TD]DMR[/TD]
[TD]65[/TD]
[TD]58%[/TD]
[TD]ABC[/TD]
[/TR]
[TR]
[TD]VA 58 4% DEF[/TD]
[TD]VA[/TD]
[TD]58[/TD]
[TD]4%[/TD]
[TD]DEF[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
How can this be done?
Not sure if the table will show what I am trying to achieve. I would like field 2 to start 8 characters in from the beginning of the string, the 3rd field at 16 characters, and the 4th field at 24 characters in...
thanks,
Dan
Last edited: