I have a column with the information like the following: 20016ConsumerHD
I'm trying to separate the number (20016) from the name (ConsumerHD), is there any way to do this? The number is always 5 characters long, maybe pull the first 5 characters?
I have a column with the information like the following: 20016ConsumerHD
I'm trying to separate the number (20016) from the name (ConsumerHD), is there any way to do this? The number is always 5 characters long, maybe pull the first 5 characters?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks