• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

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


0
MikeMCSD
Asked:
MikeMCSD
  • 2
  • 2
1 Solution
 
barry houdiniCommented:
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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now