Extracting abbreviated days, converting to full word
 

The following type of data are listed in a column of cells:
Mon 1:30 (4:30)
Mon 10 (1)
Thurs 2 (5)

I need to get the day into another cell and converted to a full day name:
Mon = Monday

My simple extration formulas aren't working since the abbreviated days very
from 3-4 character spaces.

Extracting abbreviated days, converting to full word
 

=left(A1,find(" ",a1)-1)&"day"

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Sneilan" wrote in message
...
The following type of data are listed in a column of cells:
Mon 1:30 (4:30)
Mon 10 (1)
Thurs 2 (5)

I need to get the day into another cell and converted to a full day name:
Mon = Monday

My simple extration formulas aren't working since the abbreviated days
very
from 3-4 character spaces.

Extracting abbreviated days, converting to full word
 

In your extraction formulas, rather than using the entire cell (ie, 'Thurs'),
use Left(cell,3). That way, you'll always be using the standard 3-letter day
abbreviation.

--
Regards,
Fred


"Sneilan" wrote in message
...
The following type of data are listed in a column of cells:
Mon 1:30 (4:30)
Mon 10 (1)
Thurs 2 (5)

I need to get the day into another cell and converted to a full day name:
Mon = Monday

My simple extration formulas aren't working since the abbreviated days very
from 3-4 character spaces.

Extracting abbreviated days, converting to full word
 

One play ..

Assuming source data as posted is in A1 down

Put in B1, array-enter* to confirm the formula:
=INDEX({"Monday";"Tuesday";"Wednesday";"Thursday"; "Friday";"Saturday";"Sunday"},MATCH(TRUE,ISNUMBER( SEARCH({"Mon";"Tue";"Wed";"Thu";"Fri";"Sat";"Sun"} ,A1)),0))
Copy down as far as required. Col B should return the required results:
Monday, Thursday, etc

*Press CTRL+SHIFT+ENTER
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sneilan" wrote:
The following type of data are listed in a column of cells:
Mon 1:30 (4:30)
Mon 10 (1)
Thurs 2 (5)

I need to get the day into another cell and converted to a full day name:
Mon = Monday

My simple extration formulas aren't working since the abbreviated days very
from 3-4 character spaces.

Extracting abbreviated days, converting to full word
 

Assuming your data starts in A1 (change to suit), use this...

=TEXT(MATCH(LEFT(A1,2),{"Su","Mo","Tu","We","Th"," Fr","Sa"},0),"dddd")

and copy down as far as necessary.

Rick


"Sneilan" wrote in message
...
The following type of data are listed in a column of cells:
Mon 1:30 (4:30)
Mon 10 (1)
Thurs 2 (5)

I need to get the day into another cell and converted to a full day name:
Mon = Monday

My simple extration formulas aren't working since the abbreviated days
very
from 3-4 character spaces.