Delete partial string

[an]

Hello!

I have a column with strin in cells

26-02-2004 09:27 jhfkfhg fhgfjfg
26-02-2004 10:28 ewqteter rerewewtrre

I know delete date/hour group with Replace, but I need
inverse.
Preserv date/hour group and delete only alfanumeric string.
Is possible in Excel?

Thanks in advance.
an

 

[Frank Kabel]

Hi
one way (if your data is always structured as below)
- add a helper column (lets say B)
- insert the following formula in B1 (if column A stores your data):
=LEFT(A1,FIND(":",A1)+2)
copy down

- now you can copy this row and insert it again with 'Paste Special -
Values'

 

[an]

Ok!
Many thanks.
an

-----Original Message-----
Hi
one way (if your data is always structured as below)
- add a helper column (lets say B)
- insert the following formula in B1 (if column A stores your data):
=LEFT(A1,FIND(":",A1)+2)
copy down

- now you can copy this row and insert it again with 'Paste Special -
Values'


--
Regards
Frank Kabel
Frankfurt, Germany


.