How to delete a line from Excel cell
Solved/Closed
mahfuz19
Posts
4
Registration date
Sunday 10 November 2013
Status
Member
Last seen
16 February 2014
-
10 Nov 2013 à 13:38
mahfuz19 - 20 Nov 2013 à 09:21
mahfuz19 - 20 Nov 2013 à 09:21
Related:
- How to delete a line in excel
- How to remove a line in excel - Best answers
- How to remove line in excel - Best answers
- Sed delete line - Guide
- How to delete duplicates in excel - Guide
- How to delete a row in word - Guide
- How to change date format in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
12 Nov 2013 à 11:31
12 Nov 2013 à 11:31
Hi Mahfuz19,
Not clear. What line?
Best regards,
Trowa
Not clear. What line?
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
18 Nov 2013 à 10:23
18 Nov 2013 à 10:23
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
17 Nov 2013 à 11:31
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