I have 3 CSV files I combine into one spreadsheet and upload to another program. The program they go into has a limit of 25 characters, but the program the information comes from has a limit of 40. Is there a way within Excel to trim those columns back to 25 characters? I thought about using Access instead of Excel, but I'm fairly new at both, and I couldn't figure out how to append my 3 files into one table. Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Limit the length of text in a column
- Thread starter Robyne
- Start date
bluedragon2
IS-IT--Management
How would you want to trim it?
Blue
Blue
- Thread starter
- #3
bluedragon2
IS-IT--Management
Lets say the data is column A, in Column B1, put:
=left(A1,25)
then paste it down.
This will give you the first 25 characters of column A in column B.
You may then want to copy column B and do a paste special to another column so you will have text instead of formula values.
Blue
=left(A1,25)
then paste it down.
This will give you the first 25 characters of column A in column B.
You may then want to copy column B and do a paste special to another column so you will have text instead of formula values.
Blue
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question