| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
left/right or center ?
I have days off in the P column in this format: Sat/Sun
I'm using them in another column in this format SatSun, so I'm using this formula: =LEFT(P21,3)&RIGHT(P21,3), which produces SatSun However, I have some days off that just have Sun, which produces SunSun. How can the formula be writen to produce SatSun when two days are showing, and only Sun when one day is showing ? Thanks, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge and Center and Center Accross Selection | New Users to Excel | |||
| merged cells don't center over columns to repeat at left | Excel Discussion (Misc queries) | |||
| How do I left justify center section header | Excel Discussion (Misc queries) | |||
| Want to use left and center footer in same page | Charts and Charting in Excel | |||
| Want to use left and center footer on same page | Excel Discussion (Misc queries) | |||
Threaded Mode
