smith@thomas - Split and Concatenate

[sachinattri]

Hi,

I have a list of names for example

smith@john
reynolds@lawrence

I want the First and Last Names separated into two columns. How do
break the rows if I want the new columns to show SMITH and the secon
column to show JOHN.

Similarly what can I do for the dates I have in in mm-dd-yyyy format

6182004
12012004

Thank you in advanc

 

[Frank Kabel]

Hi
try using 'Data - Text to columns' and use '@' as delimiter

 

[sachinattri]

Thanks Frank.

What do I do with the DATES, also if I want them back to sho
06/18/2003?

Thanks again, I should have thought of this before

 

[Frank Kabel]

Hi
you could also use Data - Text to columns (if they all have the same
format). or use a formula like
=DATE(RIGHT(A1,4),LEFT(A1,1+(LEN(A1)=8)),MID(A1,2+(LEN(A1)=8),2))

 

[Dave Peterson]

This worked ok with my USA settings:

=DATEVALUE(TEXT(A1,"00\/00\/0000"))

Format the cell as mm/dd/yyyy