Un - Concatenate?

Hi

Why don't you insert the necessary columns (2 in this case), then do
Data|Text to Columns, select delimited, select Space (and unselect Tab) to
split it into columns

"JudithJubilee" wrote:

> Hello there,
>
> I have a large list of police records and one of the fields contains their,
> ID Code, Area and Rank seperated by spaces. I know there is a LEN and FIND
> fuction but how do I conbine these??
>
> Thankyou in advance
>
> Judith

Hi

Why don't you insert the necessary columns (2 in this case), then do
Data|Text to Columns, select delimited, select Space (and unselect Tab) to
split it into columns

"JudithJubilee" wrote:

> Hello there,
>
> I have a large list of police records and one of the fields contains their,
> ID Code, Area and Rank seperated by spaces. I know there is a LEN and FIND
> fuction but how do I conbine these??
>
> Thankyou in advance
>
> Judith

Hello there,

I have a large list of police records and one of the fields contains their,
ID Code, Area and Rank seperated by spaces. I know there is a LEN and FIND
fuction but how do I conbine these??

Thankyou in advance

Judith

Hi

Why don't you insert the necessary columns (2 in this case), then do
Data|Text to Columns, select delimited, select Space (and unselect Tab) to
split it into columns

"JudithJubilee" wrote:

> Hello there,
>
> I have a large list of police records and one of the fields contains their,
> ID Code, Area and Rank seperated by spaces. I know there is a LEN and FIND
> fuction but how do I conbine these??
>
> Thankyou in advance
>
> Judith