Separating Data

  • Thread starter Thread starter DaveB
  • Start date Start date
D

DaveB

Hi...I have 4045 rows of data that look like this:

16TH FL BENN TOWER/4385
3900 CHESTNUT/6178

I need to separate out the 4 diget code after the /...so
it's in a column by itself. Can you help me with the code.

Thank you.

DaveB
 
Dave,

I'm not sure you need code, try this

Make sure you have a blank column next to your
range then:

Select your range containing the data
from the menu choose Data -> Text to Columns
choose Delimited and hit next
under the delimiters heading choose Other and
type in a "/" (without quotes)
hit finish

Dan E
 
Dave,

Using cell A1 as an example.
Two ways (there are others).....
If it's always the rightmost 4 characters.......
=RIGHT(A1,4)
If it's always the 4 characters after the slash....
=MID(A1,FIND("/",A1)+1,4)

John
 
Dave

Select your column and choose Data, Text to Columns. Click
OK for the first screen. Choose Other separator on the
second and enter / in the check box.

The slash is removed and the data is separated.

Regards
Peter
 
Or you can use the following formula:

=right(A1,4) in the next column and drag it thru 4000 rows


hope it helps
 
Or you can use the following formula:

=right(A1,4) in the next column and drag it thru 4000 rows


hope it helps
 
Or you can use the following formula:

=right(A1,4) in the next column and drag it thru 4000 rows


hope it helps
 
Or you can use the following formula:

=right(A1,4) in the next column and drag it thru 4000 rows


hope it helps
 
Or you can use the following formula:

=right(A1,4) in the next column and drag it thru 4000 rows


hope it helps
 
Or you can use the following formula:

=right(A1,4) in the next column and drag it thru 4000 rows


hope it helps
 
Or you can use the following formula:

=right(A1,4) in the next column and drag it thru 4000 rows


hope it helps
 
Back
Top