Delete Prefix in each cell

[Pete2020]

Is there any VBA Or Custom Function or Formula which help in removing the prefix numbers and alphabets at the starting of each sentence.

Book1
	A	B
1	RAW Data	Expected Output
2	1. TAS Balagopal – Export management – Himalaya	TAS Balagopal – Export management – Himalaya
3	2. Varshney & Battacharya – International Marketing Sultanchand & sons	Varshney & Battacharya – International Marketing Sultanchand & sons
4	3. Francis chernmilam – International Trade and Export management – Himalaya	Francis chernmilam – International Trade and Export management – Himalaya
5	4. B.S Rathor – Export Management – Himalaya.	B.S Rathor – Export Management – Himalaya.
6	5. S. Shivaramu – Export Marketing – Himalaya	S. Shivaramu – Export Marketing – Himalaya
7	Unit – I: Concept of Security	Unit – I: Concept of Security
8	a) Meaning, definition and Objectives	Meaning, definition and Objectives
9	b) Elements of National Security	Elements of National Security
10	c) Kinds of National Security	Kinds of National Security
11	REFERENCES	REFERENCES
12	1) Barry Buzon., People, State and Fear	Barry Buzon., People, State and Fear
13	2) Bajpai, U.S.,(ed) India’s Security	Bajpai, U.S.,(ed) India’s Security
14	3) Dixit, J.N., Accross Borders	Dixit, J.N., Accross Borders
15	4) Satish Kumar, (ed)	Satish Kumar, (ed)
16	5) Jayaramu, P.S., India’s National Security and Foreign Policy	Jayaramu, P.S., India’s National Security and Foreign Policy
17	6) Kaul, T.N., India and the New World	Kaul, T.N., India and the New World
18	7) Kux, Dennis, Estranged Democracies	Kux, Dennis, Estranged Democracies
19	1.1 NMR Spectroscopy	NMR Spectroscopy
20	2.1 Interpretation of NMR spectra	Interpretation of NMR spectra
21	3.1 Mass spectroscopy	Mass spectroscopy
22	4.1 Interpretation of mass spectra	Interpretation of mass spectra
23	5.1 E.S.R.Spectroscopy	E.S.R.Spectroscopy
24	a. Meaning, definition and Objectives	Meaning, definition and Objectives
25	b. Elements of National Security	Elements of National Security
26	c. Kinds of National Security	Kinds of National Security
27	Unit – IV: The State Administration	Unit – IV: The State Administration
28	(a) The Governor- role and powers of Governor.	The Governor- role and powers of Governor.
29	(b) The role and function of the Chief Minister.	The role and function of the Chief Minister.
30	(c) The State legislature – its role & functions.	The State legislature – its role & functions.
31	Unit – IV: The Central Administration	Unit – V: The Central Administration
32	(1.) The President- role and powers of President	The President- role and powers of President
33	(2.) The role and function of the Mayor	The role and function of the Mayor
34	(3.) The State legislature – its role & functions.	The State legislature – its role & functions.
35	Unit – VI: The Central Administration	Unit – VI: The Central Administration
36	(1). The President- role and powers of President	The President- role and powers of President
37	(2). The role and function of the Mayor	The role and function of the Mayor
38	(3). The State legislature – its role & functions.	The State legislature – its role & functions.
39	Unit – VII: Concept of Security	Unit – VII: Concept of Security
40	(a). Meaning, definition and Objectives	Meaning, definition and Objectives
41	(b). Elements of National Security	Elements of National Security
42	(c). Kinds of National Security	Kinds of National Security
Sheet1

EDIT:
Please remove this pattern as well after applying the macro

(i) Basic Accounting Equation.
(ii) Basic Accounting Liability.
(iii) Basic concept of IFRS.

 

[Tricepsratops]

Hello. I see that all your prefixes end with a SPACE. So I came up with a formula that trims the text up to the first space.
The problem is that you dont want to cut the "Unit-#" ones, so I did a special situation for them.
the iferror avoid trouble with rows with no space like row 11.

Spanish:
=SI.ERROR(SI(ESNUMERO(HALLAR("Unit*";A2))=VERDADERO;A2;DERECHA(A2;LARGO(A2)-HALLAR(" ";A2)));A2)

English: (translation may not be accurate)
=IFERROR(IF(ISNUMBER(SEARCH("Unit*",A2))=TRUE,A2,RIGHT(A2,LEN(A2)-SEARCH(" ",A2))),A2)

I'm sure this isn't the best code but it works for me. Once you get the result, you can select the cells and copy paste as text and you will get cells with only your desired text.

 

[Pete2020]

@Tricepsratops

Thank you so much.Its Working

 

[Dave87]

Check if row 27 is ok, the first space is after "Unit"

 

[Pete2020]

Its actually correct.