EXTRACT all characters from a string

[Blake 7]

Hi guys - still having a very blonde moment.... am trying to extract all characters from a string AFTER the -

tried this but am getting #value error

=MID(A29,FIND("-",A29)+1,100)

for eg

I have

Age - blahblah

i want to extract blahblah

Thanks

[DonkeyOte]

I would be inclined to use REPLACE

Please Login or Register  to view this content.

Your current approach is ok (assuming you have fewer than 100 chars post hyphen) but you would get the error you describe if there were no hyphen present

see also TRIM if you want to remove leading / trailing spaces etc...

[Blake 7]

Thanks dude