Excel Remove Numbers

[ziad alsayed]

dear all

with the below data , how can i remove the numbers and keep the remaining

Excel Workbook
	G
2	4111100024 1 FELPET NIG LTD
3	4111100073 1 CONCORD HOTEL
4	4111100541 1 OCEANIC BANK PLC
5	4111100681 1 RIVERS VEGETABLE OIL CO. LTD
6	4111100961 1 MONIPULO
7	4111101057 1 FRANCIS
8	4111101110 1 CEW NIG. LTD.
TopTen

Excel 2010

Appreciate any help

 

[crook_101]

Hi,

If there is the same amount of numerics at the dtart, something simple like:

=RIGHT(A3, LEN(A3)-12)

Should do the job, adjust the "12" for the number of characters to remove


Cheers,
Ian

 

[AMAS]

Hi Ziad,

Put this formula in Cell"H2" (or wherever you want it:

=MID(G2,13,32767)

The assumption is that there are 13 spaces (numbers and spaces) before the data you want.

Good luck.

AMAS

 

[ziad alsayed]

thanks Crook_101 and thansk AMAS , both works.
the number of characters is 13.

Appreciate your help