Simple question

[quarefella]

I have a spreadsheet with thousands of rows of data each with a UK postcodes... e.g. PA19 1UW. I want to create another column showing the first 2 characters of the post code only, e.g. PA

I am sure there is a formula to do his but I just can't work it out.

Thanks

tc

 

[RAM]

Book1
	A	B	C	D
1	PA19 1UW	PA
2
Sheet2

Welcome to the board!

Hope this helps

Edit: Copy B1, select B2, scroll down to the last row with postal numbers, hold down Shift and select the last cell in Column B. This should select all cells in Column B you want to fill. Then right-click on that selection and paste.

RAM

 

[Brian from Maui]

You could also use Data/Text to Columns and select fixed width

 

[quarefella]

Thanks chaps.... I am up & running now.

tc