| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Left Function
I am trying to sort only the left 6 characters of a column. I could not find
where I could select and sort only the first 6 characters so I created another column 'B' and used the B1=LEFT(A1,6). I used the formula box to verify format and the result was correct, but when I hit enter only ths function showed in the cell B1. What am I doing wrong? It's driving me crazy! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| Left vs Left$ function | Excel Discussion (Misc queries) | |||
| LEFT function | Excel Discussion (Misc queries) | |||
| Left function | Excel Discussion (Misc queries) | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
Threaded Mode
