Forum Discussion
How to copy only clipped text in a cell OR delete multiple lines of characters from a specific point
Hi there! First time posting on here and I'm hoping I'll be able to get some help. I am using excel to load contact phone numbers I exported from google. The problem is that googles only fo...
AnthonyMaffei Anthony, you can create a new column to limit the text to 10 characters by using
=left(A1,10) where A1 is the text you are trying to truncate - revise as appropriate. This, then, could be copied and pasted as needed.
While you may be limited to your export functionality, you are not limited by your import functionality. It's very likely your data could be transformed during the import process using "Get Data" within the data menu to give you exactly the info you're looking for.
If you'd be willing to share something representative of the data after removing any personal information I can show you. If you'd prefer, you can PM me the file.