J
jock
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.
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.