| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FIND Beginning of field and add C to end of the field
Hi,
I have a list of parts in Column A. I want to do a macro to find lets say beginning 4 characters of the part and when it find to add letter C at end of the part Example. TESTAB XZZZTT TESTPART So lets say I'm searching for TEST, so my end result I'm looking is the following TESTC TESTPARTC Would appreciate any help Thank you, Juan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula, one field complex or multiple table field simple | Excel Discussion (Misc queries) | |||
| How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
| Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
| Formula to find average of field for all rows that contain another field | Excel Programming | |||
| How do i insert information into the beginning of every field? | Excel Discussion (Misc queries) | |||
Threaded Mode
