Bring big text paragraph in the cell to the new column

geetethan

New Member
Joined
May 19, 2016
Messages
8
here is how have articles in cell.
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]aaaaaaaaaaa(small line)
(one enter is in this line)
bbbbbbbbbbbbbbbbbbbbbbbbbbbbb(very big text content without enter)
(one enter in this line)
ccccccc(very small content)
(one enter in this line)
ddddddd(very small content)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]













I want to filter out the bbbbbbbbbbbbbbbbb( the very big text content without enter) in the column B, just next to it.
it will look like this when achieved
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]aaaaaaaaaaa(small line)
(one enter is in this line)
bbbbbbbbbbbbbbbbbbbbbbbbbbbbb(very big text content without enter)
(one enter in this line)
ccccccc(very small content)
(one enter in this line)
ddddddd(very small content)[/TD]
[TD]bbbbbbbbbbbbbbbbbbbbbbbbbbbbb[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

hOW I CAN ACHIVE THIS, THAK YOU VERY MUCH.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
What determines that a line of text is a "very big text content"... the number of characters? If so, what is the magic number which divides "not very big text" from "very big text"? If not, then you need to provide more detail on how we determine which line of code meets your definition of "very big text content".
 
Upvote 0
What determines that a line of text is a "very big text content"... the number of characters? If so, what is the magic number which divides "not very big text" from "very big text"? If not, then you need to provide more detail on how we determine which line of code meets your definition of "very big text content".

view this and help me out please. my work has been stopped due to this ...
 
Upvote 0

Forum statistics

Threads
1,223,275
Messages
6,171,121
Members
452,381
Latest member
Nova88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top