How to delete a line from Excel cell
Solved/Closed
mahfuz19
Posts
4
Registration date
Sunday November 10, 2013
Status
Member
Last seen
February 16, 2014
-
Nov 10, 2013 at 01:38 PM
mahfuz19 - Nov 20, 2013 at 09:21 AM
mahfuz19 - Nov 20, 2013 at 09:21 AM
Related:
- How to delete a line from Excel cell
- Sed delete line - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Excel cell color formula - Guide
- How to delete part of a table in word - Guide
- How to delete skype account permanently - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Nov 12, 2013 at 11:31 AM
Nov 12, 2013 at 11:31 AM
Hi Mahfuz19,
Not clear. What line?
Best regards,
Trowa
Not clear. What line?
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Nov 18, 2013 at 10:23 AM
Nov 18, 2013 at 10:23 AM
Hi Mahfuz,
To my knowledge it is not possible, since the middle line changes upon the column width.
What is left is to search for other similarities (structures) between the cells.
Like remove the entry between the 2nd and the 3rd space,
or remove the numbers,
or remove the entry after a certain amount of characters.
If I were you I would split my data across multiple cells especially if you want to use formula's on them.
Best regards,
Trowa
To my knowledge it is not possible, since the middle line changes upon the column width.
What is left is to search for other similarities (structures) between the cells.
Like remove the entry between the 2nd and the 3rd space,
or remove the numbers,
or remove the entry after a certain amount of characters.
If I were you I would split my data across multiple cells especially if you want to use formula's on them.
Best regards,
Trowa
Nov 17, 2013 at 11:31 AM
Suppose in a cell i write the following lines:
" mahfuz haque
123456789
going home"
Now i want to delete the mid line(123456789) by using excel formula not VBA as i can not understand it.
For your information say i have 30 cell(each have 3 line) in a column.
Thanking in advance.
regards
Mahfuz