Separating information from a single cell

Originally Posted by rofl

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?

Try this:

Suppose your data is in A1

B1

=Left(A1,5)

Enter

Hope this helps.