Formula help

Follow the procedure in order to separate Invoice number and date

1. Select the column in which data contains
2. Click on "Data" tab under which select "Text to columns"(TTE).
3. On clicking TTE a box will open in which select delimit as option and choose next.
4. After in Others section , paste the symbol "/" and click next again and then finish.

That's it u will get it separated into two columns

Sir i already applied but in this type of invoices its not working

 R/1878 / 3-4-2018

R/1879 / 3-4-2018

 

Use Concatenate Formula, after as suggested above, for R/1878 types of invoices

Sir it is possible for you to share formula with example