Seperating Letters from words using character

H

HelpMe

I need help trying to seperate lsome letters from numbers. I have dat
that is input into a text file that I then Import into Excel and I nee
to get only the information after the : in all the collumns

Here is what is coming in:

Course In: S 70-51-41 W
RP North: 20072.05
End North: 20217.05
Line Course: N 75-25-48 E

I need to be able to seperate everything after the : is there a way t
do this?? Thanks for any help
 
C

chris

Use this
Stick a blank column next to each Column with the data you want extraction from and copy down for each
=RIGHT(A1,LEN(A1)-FIND(":",A1,1)

----- HelpMe > wrote: ----

I need help trying to seperate lsome letters from numbers. I have dat
that is input into a text file that I then Import into Excel and I nee
to get only the information after the : in all the collumn

Here is what is coming in

Course In: S 70-51-41
RP North: 20072.0
End North: 20217.0
Line Course: N 75-25-48

I need to be able to seperate everything after the : is there a way t
do this?? Thanks for any help
 
G

Gord Dibben

You have posted in the Programming group, but I will give a non-programming
solution.

Select your data. Data>Text to Columns>Delimited>Next. In "other" enter a
colon:))>Next

You can choose to "skip a column-do not import" if you wish.

Finish.

Gord Dibben Excel MVP
 
Top