Solved

How to trim a column down to 50 characters.

Posted on 2011-09-21
4
167 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
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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

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,…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 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