• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

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
0
recycleaus
Asked:
recycleaus
1 Solution
 
quizwedgeCommented:
You can try the Left function. For example, LEFT(A1,3)
0
 
recycleausAuthor Commented:
Thanks quiz
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now