Mansoori M. Zubair M.salim (M.Com / IPCC cum ATC / CA Final) (208 Points)
17 April 2019Dear 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 |
Vinay
(Article student)
(23 Points)
Replied 17 April 2019
Mansoori M. Zubair M.salim
(M.Com / IPCC cum ATC / CA Final)
(208 Points)
Replied 18 April 2019
Sir i already applied but in this type of invoices its not working
R/1878 / 3-4-2018
R/1879 / 3-4-2018
CA Ankit Garg
(MD | Genuine Filings)
(781 Points)
Replied 18 April 2019
Mansoori M. Zubair M.salim
(M.Com / IPCC cum ATC / CA Final)
(208 Points)
Replied 18 April 2019
CAclubindia
