Go AD-Free with CAclubindia Pro and Daily Mobile Updates. Subscribe Now!

Formula help

140 views 4 replies

Mansoori M. Zubair M.salim

M.Com / IPCC cum ATC / CA Final

208 Points Joined June 2010

Dear All

I want excel formula to extract only invoice numbers from Purchase Register export from Tally eg

GST77717 / 2-4-2018

402934 / 2-4-2018

683620 / 2-4-2018

383622 / 2-4-2018

3875 / 2-4-2018

683621 / 2-4-2018

100364 / 2-4-2018

U03-18-1337 / 3-4-2018

U03-18-1331 / 3-4-2018

403008 / 3-4-2018

R/1878 / 3-4-2018

R/1879 / 3-4-2018

I required only invoice numbers for GSTR2 Reco

Please help

Replies (4)

Vinay

Article student

23 Points Joined February 2018

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