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

--
Message posted from http://www.ExcelForum.com

Use this
Stick a blank column next to each Column with the data you want extraction from and copy down for each

This would go in cell B1 of Column
=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


--
Message posted from http://www.ExcelForum.com

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

Select your data. DataText to ColumnsDelimitedNext. In "other" enter a
colon(:)Next

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

Finish.

Gord Dibben Excel MVP

On Fri, 23 Apr 2004 14:08:37 -0500, HelpMe
wrote:

I need help trying to seperate lsome letters from numbers. I have data
that is input into a text file that I then Import into Excel and I need
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 to
do this?? Thanks for any help.


---
Message posted from http://www.ExcelForum.com/