Link to home
Start Free TrialLog in
Avatar of MikeMCSD
MikeMCSDFlag for United States of America

asked on

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


ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MikeMCSD

ASKER

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.

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
thanks!