Related:
- How to delete a line from Excel cell
- How to remove apostrophe in excel cell - How-To - Excel
- How to insert picture in excel cell automatically from folder - Forum - Excel
- Screenshot excel cells - How-To - Excel
- Excel cell flash when date is near ✓ - Forum - Excel
- Edit excel cell without double clicking ✓ - Forum - Excel
2 replies
TrowaD
- Posts
- 2805
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- September 14, 2021
Hi Mahfuz19,
Not clear. What line?
Best regards,
Trowa
Not clear. What line?
Best regards,
Trowa
TrowaD
- Posts
- 2805
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- September 14, 2021
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
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