Parse out field values

[rjplante]

I have a cell that has text with a dash in the middle (xxxx-xxxxA). Sometimes there are 4 characters and sometimes there are 5. I would like to take all the text to the right of the dash regardless of the number of characters and place that into another cell. If I use the right(A1,5) formula, it works for one with 5 charachters, but for one with 4 it also takes the dash. What can use formula wise to achieve this?

 

[Fluff]

How about
=mid(a1,find("-",a1)+1,100)

 

[Rick Rothstein]

Try it this way...

=MID(A1,FIND("-",A1)+1,9)

 

[sandy666]

with Power Query

raw		raw.1	raw.2
xxxx-xxxxA		xxxx	xxxxA
xx-xxxxA		xx	xxxxA
xxxx-xA		xxxx	xA
xxxx-xxA		xxxx	xxA
x-xxxxA		x	xxxxA

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Split = Table.SplitColumn(Source, "raw", Splitter.SplitTextByDelimiter("-", QuoteStyle.Csv), {"raw.1", "raw.2"})
in
    Split

or

raw	TAD
xxxx-xxxxA	xxxxA
xx-xxxxA	xxxxA
xxxx-xA	xA
xxxx-xxA	xxA
x-xxxxA	xxxxA

let
    Source = Excel.CurrentWorkbook(){[Name="Table"]}[Content],
    TAD = Table.AddColumn(Source, "TAD", each Text.AfterDelimiter([raw], "-"), type text)
in
    TAD

or even like this

raw		TAD
xxxx-xxxxA		xxxxA
xx-xxxxA		xxxxA
xxxx-xA		xA
xxxx-xxA		xxA
x-xxxxA		xxxxA

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    TSC = Table.SelectColumns(Table.AddColumn(Source, "TAD", each Text.AfterDelimiter([raw], "-"), type text),{"TAD"})
in
    TSC

 

[rjplante]

Thank you all for the quick response. Fluff and Rick had the same formula which is what I was looking for and the formula works great. Sandy, Thanks for the VBA as I always like to learn something new and this has given me something to study.

 

[sandy666]

Sandy, Thanks for the VBA

this is NOT vba but M for Power Query

 

[Fluff]

Glad we could help & thanks for the feedback.