seperate text within a cell

[Garry Kennedy]

Hi,

I have a series of cells that have numbers in the following format - "92 -
16 - 76" (It represents the gross score of a golfer in a competition, less
his handicap and his net score). Is there any formula I can use to extract
these numbers into seperate cells?

Garry

 

[Garry Kennedy]

Hi,

I have a series of cells that have numbers in the following format - "92 -
16 - 76" (It represents the gross score of a golfer in a competition, less
his handicap and his net score). Is there any formula I can use to
extract these numbers into seperate cells?

Garry

Note / PS: The cell is formatted as text and the second dash is in fact am
equals sign (92 - 16 = 76)

 

[Don Guillett]

Lots of ways
Data>text to columns>
formulas using FIND and MID
macros using INSTR

 

[L. Howard Kittle]

Hi Garry,

What I did with your example was to use this formula (and pull down) to get
rid of the "=" sign and put in an "-" in its place.

=SUBSTITUTE(A1,"=","-")

Then select the scores and Copy > Paste Special > Values in place (or to
another location if desired to keep the original score list). Now select
the list of scores and use Text To Columns under Data with the delimiter as
"-".

HTH
Regards
Howard

 

[Garry Kennedy]

Thanks a million Howard, Don meant well, but you explained what you meant
..... worked first time.

Cheers

Garry