•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can I split columns by number of characters/ digits?
I have a list of addresses for a mailing I need to complete. The zip codes column is supposed to read #####-####, but for whatever reason, the hyphen was lost and I'm left with all 9 digits straight. Is there a function I can use to either separate the columns, add the hyphen after the 5th digit, or even just get rid of the last 4 digits altogether?
I just need something I can work with for a mail merge, without manually having to change the couple hundred entries. The last 4 digits are nice, but not necessary. I tried using text to columns but since there is no delimitator, I didn't get far.
Any advice is appreciated! TIA
- Excel Version Office 365 version 2603; Build 19822.20114
- Excel Environment: desktop, Windows
- Excel Language English
- Your Knowledge Level: Formerly intermediate/advanced, but its been almost a decade since it was a daily work task, I'm extremely rusty
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#Excel compatibility
#Excel alternatives
#generative AI for data analysis
#financial modeling with spreadsheets
#rows.com
#enterprise-level spreadsheet solutions
#natural language processing
#zip codes
#Excel
#mail merge
#columns
#hyphen
#digits
#function
#separate
#delimitator
#characters
#format