I am using a spreadsheet that imports data from our Traffic System. One of
the fields pulls through a 3 letter field but also pulls through a list of
0's and the odd letter after it which we do not need.

I can seperate these with Text to Column so one column just shows the 3
letter code, but when we refresh the data from Query it does not update the
text to column from the updated data column.

Is there a way that this can be done, or is there another way to seperate
the data. It comes through like this - GBR 00000000Y 0
and i just want the GBR bit.

Very difficult to be precise with knowing how the data are imported but a
couple of thoughts

instead of copying thevalue GBR 000000000 0
copy left(variable_name,3)

or import the data, select it then do a replace with
Edit|Replace

Replace what GBR*
Replace with GBR

Mike

"jock" wrote:

I am using a spreadsheet that imports data from our Traffic System. One of
the fields pulls through a 3 letter field but also pulls through a list of
0's and the odd letter after it which we do not need.

I can seperate these with Text to Column so one column just shows the 3
letter code, but when we refresh the data from Query it does not update the
text to column from the updated data column.

Is there a way that this can be done, or is there another way to seperate
the data. It comes through like this - GBR 00000000Y 0
and i just want the GBR bit.

Well the data is imported just as normal text, exactly what I showed before.
It is pulled through from Microsoft Query. The first 3 digits are different
in a lot of cases, and when we refresh the data the data will not be in the
exact cell, but the same column, heading of Job Type.

I am not very up on Excel, so if you could explain exactly how to do it
would be great.

"Mike H" wrote:

Very difficult to be precise with knowing how the data are imported but a
couple of thoughts

instead of copying thevalue GBR 000000000 0
copy left(variable_name,3)

or import the data, select it then do a replace with
Edit|Replace

Replace what GBR*
Replace with GBR

Mike

"jock" wrote:

I am using a spreadsheet that imports data from our Traffic System. One of
the fields pulls through a 3 letter field but also pulls through a list of
0's and the odd letter after it which we do not need.

I can seperate these with Text to Column so one column just shows the 3
letter code, but when we refresh the data from Query it does not update the
text to column from the updated data column.

Is there a way that this can be done, or is there another way to seperate
the data. It comes through like this - GBR 00000000Y 0
and i just want the GBR bit.