Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Removing digits from exel 2007 column

Posted on 2011-09-05
Medium Priority
301 Views
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
0
Question by:mmalik15
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2
• 2

LVL 50

Accepted Solution

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 36483676
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

LVL 19

Expert Comment

ID: 36483685
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)
``````

the formula removes the first 4 characters

0

LVL 33

Expert Comment

ID: 36483686
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

LVL 50

Expert Comment

ID: 36483692
@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

LVL 19

Expert Comment

ID: 36483776
Well, it does the job in most instances and is faster to type. For longer number i use 6 or 7 ;-))
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
###### Suggested Courses
Course of the Month8 days, 15 hours left to enroll