Del first row of text out of two rows in cell
Closed
hash
-
29 Oct 2010 à 10:40
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 31 Oct 2010 à 18:00
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 31 Oct 2010 à 18:00
Related:
- Del first row of text out of two rows in cell
- Saints row 2 cheats - Guide
- How to delete a row in word - Guide
- How to repeat rows in excel - Guide
- Saints row pc download - Download - Action and adventure
- Vb net find last row in excel sheet - Guide
3 responses
RayH
Posts
122
Registration date
Tuesday 31 August 2010
Status
Contributor
Last seen
20 June 2016
26
29 Oct 2010 à 19:20
29 Oct 2010 à 19:20
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 31 August 2010
Status
Contributor
Last seen
20 June 2016
26
31 Oct 2010 à 18:00
31 Oct 2010 à 18:00
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.
