Excel 2010 query

[Louizalass]

In column A there are reference numbers which all have 7 digits a slash then another number after that, eg: 1001234/1

I want to be able to copy/past those numbers from Column A into the next column (B) but the info in that column should show only the first seven digits of the numbers in Column A - ie without the slash at the end.

I know there's a way of doing it, but I don't know what it is.

Can any of you clever people help?

Thanks in advance!
<TABLE style="WIDTH: 60pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=80><COLGROUP><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 60pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 width=80></TD></TR></TBODY></TABLE>

 

[Peter_SSs]

Uh! Oh! I then discovered I had to save the file in CSV format and when you do that the column loses the zeros again!

Back to the drawing board!

Could you rename the *.csv file as a *.txt file? Then when you open in Excel you get the text import wizard where you can specify that the column is to be imported as text, similar to to Text to Columns wizard.

 

[Louizalass]

Apparently, when I upload the data to the other database, it sorts itself out and the reference numbers appear with the zeros.

I will be doing this tomorrow, so fingers crossed it all works out!

Thanks so much for your help!

 

[Louizalass]

Yep, it uploads to the other database just fine so, once again, thanks for everyone's help!