| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a Function
I need to retrieve a character value from a given position within a text
string, how would I do that? For example, I want to pull the value of the 4th character form the word Charlie. The value would be r. What function does this? Find and Search only return the position number of the specified character. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need a Function
You would use the method described in your other post!!
Please don't multipost "Charlie" wrote: I need to retrieve a character value from a given position within a text string, how would I do that? For example, I want to pull the value of the 4th character form the word Charlie. The value would be r. What function does this? Find and Search only return the position number of the specified character. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need a Function
See your other post. Multi-posting is not necessary in these groups.
Regards, Fred. "Charlie" wrote in message ... I need to retrieve a character value from a given position within a text string, how would I do that? For example, I want to pull the value of the 4th character form the word Charlie. The value would be r. What function does this? Find and Search only return the position number of the specified character. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need a Function
Hi,
Haven't checked your other post but... =MID(A1,4,1) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Charlie" wrote: I need to retrieve a character value from a given position within a text string, how would I do that? For example, I want to pull the value of the 4th character form the word Charlie. The value would be r. What function does this? Find and Search only return the position number of the specified character. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need a Function
=MID(string,startnum,numchars)
=MID("Charlie",4,1) Or =MID(A1,4,1) if Charlie is in A1 Gord Dibben MS Excel MVP On Tue, 23 Jun 2009 07:34:01 -0700, Charlie wrote: I need to retrieve a character value from a given position within a text string, how would I do that? For example, I want to pull the value of the 4th character form the word Charlie. The value would be r. What function does this? Find and Search only return the position number of the specified character. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Linear Mode
