Removing date from cells

[graisbeck]

Hi,

I'm hoping someone can help with this problem. I would like to know how to remove the date and hyphens (in red below) from within a cell that also includes other information, like so:

Red-01/01/2015-Jumper

If it was only one or two cells then I would happily manually delete the information, but there are several hundred rows of this instance.

Thanks in advance for any help given.

[AlKey]

To remove date from the cell without formula or VBA

Highlight column, press Ctrl+F to open a Find and Replace tool and type in 'Find What:' -??/??/???? then click Replace button, and Replace All without adding anything in 'Replace With'. After that you will only have one dash left. Repeat the same one more time but this time replace '-' with one space by pressing space bar only once.

[lokicl]

Hi,

Hoping you have the values starting from Cell A1. Use the below forumula.
=LEFT(A1,LEN(A1)-(LEN(A1)-FIND("-",A1))-1)&" " & RIGHT(A1,(LEN(A1)-FIND("-",A1,FIND("-",A1)+1)))
results - Red Jumper

However, you can use the text to columns and use the "-" as delimiters and extract the required info.

Regards,
lokicl

[graisbeck]

Thanks AlKey,that's great.