seperate text within a cell

  • Thread starter Thread starter Garry Kennedy
  • Start date Start date
G

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
 
Hi,
Click to expand...
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?
Click to expand...
Garry
Click to expand...


Note / PS: The cell is formatted as text and the second dash is in fact am
equals sign (92 - 16 = 76)
 
Lots of ways
Data>text to columns>
formulas using FIND and MID
macros using INSTR
 
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
 
Thanks a million Howard, Don meant well, but you explained what you meant
..... worked first time.

Cheers

Garry
 
Back
Top