Removing digits from exel 2007 column

I want to remove leading numbers from an excel column, e.g. my column is like this
1   AlcoholConcern  
2   AlcoholFocus    
3   AlcoholInfScotl
and l want it like this
AlcoholConcern  
AlcoholFocus    
AlcoholInfScotl

thanks
mmalik15Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

You could use Text to Columns and use the Space as the delimiter

OR

use a formula like

=trim(mid(A1,find(" ",A1)+1,99))

cheers, teylyn

0
 
Arno KosterCommented:
this can be done in a number of ways, easiest would be to post this formula in cell B1, assuming that the data column is column A.

=MID(A1,5,LEN(A1)-5)

Open in new window


the formula removes the first 4 characters



0
 
Rob HensonFinance AnalystCommented:
Exactly what I was about to say but my Submit didn't work for some bizarre reason.

With a slight tweak, instead of hardcoding the 99 for the length, I used LEN(A1).

Thanks
Rob H
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
@akoster, what if the numbers go into the 10s or 100s with three spaces between number and text?

@Rob, right! I like 99. It does the job in most instances and is faster to type. For longer strings I use 999 :-))
0
 
Arno KosterCommented:
Well, it does the job in most instances and is faster to type. For longer number i use 6 or 7 ;-))
0
All Courses

From novice to tech pro — start learning today.