Check if text To column needs to be applied

[jaryszek]

Hi Guys,

i have 2 worksheets:

1 - Not needed:

Screenshot_42.png

2 - Needed:
Screenshot_43.png

For no needed you can see that columsn are fine and there is no need to use text to coumns menthod.

But in second one - Needed you see that i have to apply text to columns to separate string.

Is there any way to check if RangeToColumns should be applied ?

Please help,
Jacek

[rorya]

It depends. If the presence of a semicolon in a cell automatically means it should be applied, then that would seem to be the answer.

[jaryszek]

hmm i can check it using instr function.

So there is no other method?

Thanks!!

Jacek

[nigelog]

Can you check for delimiters - already answered...need coffee

Please Login or Register  to view this content.

[nigelog]

Rep much appreciated Jacek, have a great day

[jaryszek]

thanks you too!

Jacek

[rorya]

So there is no other method?

Why do you need another method?

[jaryszek]

I am just asking

[rorya]

Just thinking about it logically, what other approach could there be? There's nothing inherently necessary about TTC unless you need to split your data, either by field length or a delimiter.

[jaryszek]

if there is no we are done ! Thank you Rory so much!

Jacek