Trimming a Cell

[Barmoley]

Hi Guys,
This is my first topic , so please be gentle
I need to remove a blank first line from a cell, attached two cells photo.
Something with replace "chr(13)" or "chr(10)".

Thanks

[NBVC]

possibly...

=Substitute(A1,Char(10),"",1) to replace first occurance of Char(10)

[Barmoley]

Hi NBVC ,
I changed it to:
MyCell = Replace(MyCell, Chr(10), "", 1, 1) and only first chr(10) was removed.

Thanks a lot!

[NBVC]

To replace all occurances:


=Substitute(A1,Char(10),"")

[NBVC]

Hi NBVC ,
I changed it to:
MyCell = Replace(MyCell, Chr(10), "", 1, 1) and only first chr(10) was removed.

Thanks a lot!

So is this solved? Not sure....

[Barmoley]

Yes , it solved. It deletes only first "chr(10)" and that's what I need.

[NBVC]

Ok, great...

Can you please mark your thread solved...

Click your original post and click Go Advanced.

Select [Solved] from the left dropdown menu and click Submit.