•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