How do I Extract X amount characters from one cell to another

Deanna Copello · 08/03/22

Paul Newcome · 08/03/22

The first 50 characters would be

=LEFT([Order Status Comments]@row, 50)

Paul Newcome · 08/03/22

The first 50 characters would be

=LEFT([Order Status Comments]@row, 50)

Deanna Copello · 08/03/22

I'm getting unparsable.

Paul Newcome · 08/03/22

Can you provide a screenshot of the formula actually in the sheet?

Deanna Copello · 08/03/22

Original that works, but brings over everything:

Paul Newcome · 08/03/22

Did you try the formula I suggested?

Deanna Copello · 08/03/22

Ah, figured it out. I was trying it in a different sheet. this worked AMAZINGLY! thank you!

Paul Newcome · 08/03/22

Happy to help. 👍️

Best Answer