Solved

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

Posted on 2012-03-27
2
250 Views
Last Modified: 2012-03-27
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
Comment
Question by:recycleaus
2 Comments
 
LVL 14

Accepted Solution

by:
quizwedge earned 500 total points
ID: 37774573
You can try the Left function. For example, LEFT(A1,3)
0
 

Author Closing Comment

by:recycleaus
ID: 37774636
Thanks quiz
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question