| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function for all Characters after the :
I need a formuls that will take all of the Characters after a colon in
a cell. I Have: B3 = LastName : Jones B4 = LastName : Anderson I need: R3 = Jones R4 = Anderson Thanks in advance for the help. Mike3108 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function for all Characters after the :
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function for all Characters after the :
Try this:
=MID(B3,FIND(":",B3)+2,255) Copied down as needed. It appears that your second example has a double space after the ":". If the number of spaces is variable try this version: =TRIM(MID(B3,FIND(":",B3)+1,255)) Biff wrote in message oups.com... I need a formuls that will take all of the Characters after a colon in a cell. I Have: B3 = LastName : Jones B4 = LastName : Anderson I need: R3 = Jones R4 = Anderson Thanks in advance for the help. Mike3108 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function for all Characters after the :
On Jun 7, 7:51 pm, wrote:
I need a formuls that will take all of the Characters after a colon in a cell. I Have: B3 = LastName : Jones B4 = LastName : Anderson I need: R3 = Jones R4 = Anderson Thanks in advance for the help. Mike3108 Thank you to Dave Peterson and T. Valko. I tried all 3 equations and they all seem to work GREAT. Thanks Again. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function for all Characters after the :
=RIGHT(B3,LEN(B3)-FIND(":",B3)-1)
" wrote: I need a formuls that will take all of the Characters after a colon in a cell. I Have: B3 = LastName : Jones B4 = LastName : Anderson I need: R3 = Jones R4 = Anderson Thanks in advance for the help. Mike3108 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to move text 65 characters to next row in column? | Excel Worksheet Functions | |||
| Name Ranges: Function to convert special characters underscores | Excel Worksheet Functions | |||
| if function checking for numerical data vs alpha characters | Excel Worksheet Functions | |||
| Function for characters | Excel Worksheet Functions | |||
| if function, multiple characters from right | Excel Worksheet Functions | |||
Linear Mode
