•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
how to split data with "9438230/name" to "9438230" and "name"?
i know there is text to column the problem here is sometimes the name is first "name/93183", so doing the separator wont work ideally, is there a better way?
name1/1234
name2/1256
6532/name3
5432/name4
how to seperate?
if you do normal split ou would have a column like
name1
name2
6532
5432
and the other is a mess too
i want all the numbers in one column and all the names in one column, and text split will do mixed columns
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions