| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling the last 6 characters out of the filename
I've got the right file open and all my numbers are crunching nicely - but I
need to drop in the date of the "data conversion" which is contained in the last 6 characters of the filename. How do I pull those last few characters out of the filename and drop it into my string? -- Regards, John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pulling the last 6 characters out of the filename
myvar= right(mystring,6)
-- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "John Brenner" wrote: I've got the right file open and all my numbers are crunching nicely - but I need to drop in the date of the "data conversion" which is contained in the last 6 characters of the filename. How do I pull those last few characters out of the filename and drop it into my string? -- Regards, John |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pulling the last 6 characters out of the filename
Thank you, Michael!
My son's name is Michael, too! :o) -- Regards, John "Michael" wrote: myvar= right(mystring,6) -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "John Brenner" wrote: I've got the right file open and all my numbers are crunching nicely - but I need to drop in the date of the "data conversion" which is contained in the last 6 characters of the filename. How do I pull those last few characters out of the filename and drop it into my string? -- Regards, John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pulling certain characters from a string of text | Excel Discussion (Misc queries) | |||
| extract characters from filename | Excel Worksheet Functions | |||
| Pulling in the path to a filename | Excel Worksheet Functions | |||
| Pulling out specific characters | Excel Discussion (Misc queries) | |||
| pulling characters out of a string | Excel Worksheet Functions | |||
Linear Mode
