How to strip caharters off column in Excel 2010

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
LVL 23
Thomas GrassiSystems AdministratorAsked:
Who is Participating?
 
nutschCommented:
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
 
Thomas GrassiSystems AdministratorAuthor Commented:
no space in row but it worked great

Thanks for the fast responce
0
 
Tapan PattanaikSenior EngineerCommented:
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
 
Thomas GrassiSystems AdministratorAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.