Need to remove the space or extra line.

Hello Friends

In the cells A2 and A3 inputs are given and in cells C2 and C3 expected results given.

I have tried using Trim but not working.

thanks in advance.

Try

C2

Formula:

Please Login or Register  to view this content.

Drag down!!

Try this for both:

=SUBSTITUTE(A2,CHAR(10),"")

When you then copy the result and paste as value, you will see that the extra lines and spaces have gone.

Hello

Thanks to both of you ankur shukla and Ali

Your formulas working well.

Thanks again

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.