How to trim a column down to 50 characters.

I want to take one text column that has more than 50 characters,
cut that field to a max of 50 characters, and put that version with only 50 characters in another column.
How do I do this? thanks


LVL 16
MikeMCSDAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
If you have text in A2 down try putting this formula in B2

=LEFT(A2,50)

If there are less than 50 characters in A2 that will give you all of them

regards, barry
0
 
MikeMCSDAuthor Commented:
thanks Barry

Do you know how to get to the end of row?
When I'm in a row and press the End key, it doesn't work.
But if I'm at the end of the row and press Home, it goes to the first column.

0
 
barry houdiniCommented:
Hello Mike,

If you want to go to the last entry in a row you can press END...and then ENTER...

Does that do it for you?

regards, barry
0
 
MikeMCSDAuthor Commented:
thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.