Single Column
July 14th, 2010
No comments
Single Column
How to convert a single column on multiple lines in Excel?
hii friends …. I have an Excel spreadsheet where I have a column and I have to distribute data in EHV lines .. for example. Suppose I have my data like that .. Prince Pedro Juan Maria Nancy Lucy now I want to do it like that .. Nancy Prince Pedro Juan Maria Lucy space will be the breaking point …. pls help ….
Use a macro. I = 1 scope while ("" + I). FormulaR1C1 <> A "Range (" B "& Round (i / 3 + 0.49)). FormulaR1C1 = Range (" A "+ i). FormulaR1C1 & "" & Range ("A" + i + 1). FormulaR1C1 i = i + 3 Wend
[affmage source="Amazon" results="5"]Single Column[/affmage]
|
|
Single Column LAVA LAMP – GREEN GLOW MOTION – NEW WAVE $13.99 |
|
|
Single Column LAVA Lamp Glow Motion Wave Color 59-219 $43.09 |
|
|
Single Column LAVA LAMP – GREEN GLOW MOTION – NEW WAVE $13.99 |
|
|
Single Column LAVA LAMP – GREEN GLOW MOTION – NEW WAVE $13.99 |
|
|
Single Column LAVA LAMP – GREEN GLOW MOTION – NEW WAVE $13.99 |
|
|
Single Column LAVA LAMP – GREEN GLOW MOTION – NEW WAVE $13.99 |
|
|
Single Column LAVA LAMP – GREEN GLOW MOTION – NEW WAVE $13.99 |
|
|
Single Column LAVA LAMP – GREEN GLOW MOTION – NEW WAVE $13.99 |
|
|
Single Column LAVA LAMP – GREEN GLOW MOTION – NEW WAVE $13.99 |
|
|
Single Column LAVA LAMP – GREEN GLOW MOTION – NEW WAVE $13.99 |
|
|
Single Column LAVA LAMP – GREEN GLOW MOTION – NEW WAVE $13.99 |
|
|
Single Column LAVA LAMP – GREEN GLOW MOTION – NEW WAVE $13.99 |