Solved

How to trim a column down to 50 characters.

Posted on 2011-09-21
4
169 Views
Last Modified: 2012-06-21
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
Comment
Question by:MikeMCSD
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 36575253
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
 
LVL 16

Author Comment

by:MikeMCSD
ID: 36575342
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
 
LVL 50

Expert Comment

by:barry houdini
ID: 36576332
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
 
LVL 16

Author Comment

by:MikeMCSD
ID: 36576511
thanks!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question