How to transfer character in a cell to other cell without cut and paste?

[yakooza]

Hello Guys,

I need help again. How can i change this:


[TABLE="width: 500"]
<tbody>[TR]
[TD]-10354493-1[/TD]
[TD]...FITTING ASSY, ELEVATOR, HORIZ STAB STA 180.0[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]/SPARES CONDITION PER PRINT EXCEPT ALL HOLES[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]IN AFT FLANGE DRILLED NO. 40 PILOT SIZE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Into this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]-10354493-1[/TD]
[TD]...FITTING ASSY, ELEVATOR, HORIZ STAB STA 180.0/SPARES CONDITION PER PRINT EXCEPT ALL HOLESIN AFT FLANGE DRILLED NO. 40 PILOT SIZE[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Without any fuss of cut and paste like 10000 rows?

Your help are a bless.

Thanks in advance.

Ash

 

[Misca]

Try something like:

Excel Workbook
	A	B	C	D	E
1	-10354494	...FITTING ASSY, ELEVATOR, HORIZ STAB STA 180.0	1	-10354494	...FITTING ASSY, ELEVATOR, HORIZ STAB STA 180.0/SPARES CONDITION PER PRINT EXCEPT ALL HOLESIN AFT FLANGE DRILLED NO. 40 PILOT SIZE
2	/SPARES CONDITION PER PRINT EXCEPT ALL HOLES
3	IN AFT FLANGE DRILLED NO. 40 PILOT SIZE
Sheet

I'm using two helper columns because this way you can just replace the original columns with the two helper ones once you've turned the formulas into values.

A macro would've been another option but with this little information about the worksheet structure it is safer to use a formula.