Solved

How to strip caharters off column in Excel 2010

Posted on 2014-03-24
4
356 Views
Last Modified: 2014-03-24
Have an excel spreadsheet with 33,000 rows

Current

A                B                                     C             D

1234     98 This is a file name       21             2
1235     54 This is another file      70            1


etc.........

the first two characters in column b I want to remove.

Result

A                B                                     C             D

1234     This is a file name       21             2
1235     This is another file      70            1

Any ideas on how I can do this
0
Comment
Question by:Thomas Grassi
[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
  • Learn & ask questions
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
ID: 39951895
Creating a new column with the following formula, then doing a copy paste value will do it.

=trim(mid(b2,3,len(b2)))

Thomas

PS: I've added the trim because it seems you have two characters plus a space to remove at the beginning. Is that correct?
0
 
LVL 23

Author Closing Comment

by:Thomas Grassi
ID: 39951908
no space in row but it worked great

Thanks for the fast responce
0
 
LVL 21

Expert Comment

by:Tapan Pattanaik
ID: 39951941
Hi trgrassijr55,

Please check this formula. It is working.

=RIGHT(B1, LEN(B1)-3)      (If want to remove first 2 number + space)

or
=RIGHT(B1, LEN(B1)-2)      (If want to remove first 2 number only)
0
 
LVL 23

Author Comment

by:Thomas Grassi
ID: 39951979
Tapan

Thanks

When I created another column to but the output in I am unable to select the entire column

Also when I copy down all the rows I am not getting the correct information
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question