How to split the data in a cell where there is a -

[Divine]

Hi There,

I need to split the text in a cell and add to two new cells for example 'business title - Company' I want to be able to split the text where there is the - character.

Can anyone please help me with this formula?

Thanks

 

[kidwispa]

Hi There,

I need to split the text in a cell and add to two new cells for example 'business title - Company' I want to be able to split the text where there is the - character.

Can anyone please help me with this formula?

Thanks

You don't need a formula for this - you can use Text to Columns to split the data, using the "-" as a delimiter...

 

[Divine]

Brilliant thank you - will use that!

 

[kidwispa]

No worries - glad to help