How do Remove Number Together Text In Excel

[silambarasan.J]

Goood Afternoon Forum leader.

I had more than 1000 records of text with number.Every time am using the find and replace its take very long time.

Please help me.

EXAMPLE

A1 B1

DATA REQUIRED FORMAT

Purchase [241] Purchase

Monday[54] Monday

Material Management [7656] Material Management

Inventory [543] Inventory

lenovo61 Lenovo

Computer [897] Computer

Stationary 33 Stationary

AUTOMOBILE58 AUTOMOBILE

Engineering Quality Control [508] Engineering Quality Control

Research plant [43] Research plant

[AlKey]

It is very difficult to understand what exactly you want.
Try this
Enter formula in B1 and copy down

Please Login or Register  to view this content.

a little bit shorter

Please Login or Register  to view this content.

v	A	B
1	Purchase [241] Purchase	Purchase
2	Monday[54] Monday	Monday
3	Material Management [7656] Material Management	Material Management
4	Inventory [543] Inventory	Inventory
5	lenovo61 Lenovo	lenovo
6	Computer [897] Computer	Computer
7	Stationary 33 Stationary	Stationary
8	AUTOMOBILE58 AUTOMOBILE	AUTOMOBILE
9	Engineering Quality Control [508] Engineering Quality Control	Engineering Quality Control
10	Research plant [43] Research plant	Research plant