Extract first 3 letters/number from a 6 digit code through formula

I do a DB dump from SQL to Excel and I have whole bunch of formulars set up to run off that data when I refresh it however one thing I have had to continually do manually is split a column (using Text to Columns) that contains a 6 digit code as I can only use the first 3 digits in my pivottable

Is there a formular which I can have set up that will automatically pull out the first 3 digits from this 6 digit code?

Thanks
recycleausAsked:
Who is Participating?
 
quizwedgeCommented:
You can try the Left function. For example, LEFT(A1,3)
0
 
recycleausAuthor Commented:
Thanks quiz
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.