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.
AB
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)

<tbody>
</tbody>













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
AB
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)
bbbbbbbbbbbbbbbbbbbbbbbbbbbbb

<tbody>
</tbody>

hOW I CAN ACHIVE THIS, THAK YOU VERY MUCH.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
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,214,911
Messages
6,122,198
Members
449,072
Latest member
DW Draft

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