Del first row of text out of two rows in cell
Closed
hash
-
Oct 29, 2010 at 10:40 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Oct 31, 2010 at 06:00 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Oct 31, 2010 at 06:00 PM
Related:
- Del first row of text out of two rows in cell
- Saints row 2 cheats - Guide
- How to delete a row in a table in word - Guide
- Saints row free download - Download - Action and adventure
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
3 responses
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Oct 29, 2010 at 07:20 PM
Oct 29, 2010 at 07:20 PM
In a new cell:
=RIGHT(A3,LEN(A3)-SEARCH("LF",A3,1))
Notice in the formula "LF". This needs to be replaced by the code for LineFeed which is 010. To type this in the formula bar press the ALT key and type 010 on the keypad. If you've typed this in correctly you'll see the formula is displayed as:
=RIGHT(A3,LEN(A3)-SEARCH("
",A3,1))
You will probably need to drag down the formula bar to see it as you normally only see one line.
What this is doing is looking for a lifefeed character in the cell, and returning is position in the string. Then, using this to find the remaining characters.
=RIGHT(A3,LEN(A3)-SEARCH("LF",A3,1))
Notice in the formula "LF". This needs to be replaced by the code for LineFeed which is 010. To type this in the formula bar press the ALT key and type 010 on the keypad. If you've typed this in correctly you'll see the formula is displayed as:
=RIGHT(A3,LEN(A3)-SEARCH("
",A3,1))
You will probably need to drag down the formula bar to see it as you normally only see one line.
What this is doing is looking for a lifefeed character in the cell, and returning is position in the string. Then, using this to find the remaining characters.
I have tried this but what he has done is
First it was like this and ? mark indicates the chinees language
?HRSG2?????1???A
Open HRSG2 HPSH 1 drain MV A
and after applying the formula it is converted into this
?HRSG2?????1???A Open HRSG2 HPSH 1 drain MV A
Now what i want is to remove the Upper line in a cell that is in chinees
Please help :(
First it was like this and ? mark indicates the chinees language
?HRSG2?????1???A
Open HRSG2 HPSH 1 drain MV A
and after applying the formula it is converted into this
?HRSG2?????1???A Open HRSG2 HPSH 1 drain MV A
Now what i want is to remove the Upper line in a cell that is in chinees
Please help :(
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Oct 31, 2010 at 06:00 PM
Oct 31, 2010 at 06:00 PM
Well this odd because I cannot replicate what I did earlier.
So, instead on pressing Alt-010 to replace LF press Alt Enter. This will insert the linefeed character instead. And is a much better solution and will give you what you need.
So, instead on pressing Alt-010 to replace LF press Alt Enter. This will insert the linefeed character instead. And is a much better solution and will give you what you need.
