Solved

How to trim a column down to 50 characters.

Posted on 2011-09-21
4
164 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
  • 2
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
thanks!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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,…
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now