Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TEXT (searching for a character)
Within cells, I have TEXT strings, such as:
A 1 abcde 2 fhjuy 3 RTgfT67%ty 4 mnl;;;opo 5 ,,, fhg' QUESTION: 1) How can I search for the, e.g. 4th character within each cell; and,...2) how can I search for the 3rd, 4th, and 5th characters? Answer 1) d, u, f, ;, " " 2) cde, juy, gfT, l;;, ," "" " Pls. advise. thank you, flkulchar |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
TEXT (searching for a character)
Hi,
you can use the following function =MID(a7,4,1) regards, julian F. Lawrence Kulchar wrote: Within cells, I have TEXT strings, such as: A 1 abcde 2 fhjuy 3 RTgfT67%ty 4 mnl;;;opo 5 ,,, fhg' QUESTION: 1) How can I search for the, e.g. 4th character within each cell; and,...2) how can I search for the 3rd, 4th, and 5th characters? Answer 1) d, u, f, ;, " " 2) cde, juy, gfT, l;;, ," "" " Pls. advise. thank you, flkulchar |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
TEXT (searching for a character)
Mid()
Tim "F. Lawrence Kulchar" wrote in message ... Within cells, I have TEXT strings, such as: A 1 abcde 2 fhjuy 3 RTgfT67%ty 4 mnl;;;opo 5 ,,, fhg' QUESTION: 1) How can I search for the, e.g. 4th character within each cell; and,...2) how can I search for the 3rd, 4th, and 5th characters? Answer 1) d, u, f, ;, " " 2) cde, juy, gfT, l;;, ," "" " Pls. advise. thank you, flkulchar |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
TEXT (searching for a character)
Thank you...
all works fine, FLKulchar "Tim Williams" <timjwilliams at gmail dot com wrote in message ... Mid() Tim "F. Lawrence Kulchar" wrote in message ... Within cells, I have TEXT strings, such as: A 1 abcde 2 fhjuy 3 RTgfT67%ty 4 mnl;;;opo 5 ,,, fhg' QUESTION: 1) How can I search for the, e.g. 4th character within each cell; and,...2) how can I search for the 3rd, 4th, and 5th characters? Answer 1) d, u, f, ;, " " 2) cde, juy, gfT, l;;, ," "" " Pls. advise. thank you, flkulchar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
Searching for records that end in a specific character | Excel Programming | |||
importing undelimited text file data, character-by-character | Excel Programming | |||
Searching for a new line character. | Excel Discussion (Misc queries) | |||
Searching a cell for a certain character. | Excel Worksheet Functions |