ssblue
asked on
Excel replace / update
Excel: 2 things and they may be similar
I need to replace some text that is between a second set of dashes Example: 11-2000-b528-3001-02 I need to replace b528 with ABC, on about a thousand items. The b528 is not always the same but the what is between the second and third dashes is what needs updated to something common.
Also
I need to replace the 9th character is a set of data.
I need to replace some text that is between a second set of dashes Example: 11-2000-b528-3001-02 I need to replace b528 with ABC, on about a thousand items. The b528 is not always the same but the what is between the second and third dashes is what needs updated to something common.
Also
I need to replace the 9th character is a set of data.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks so much for the help and the explanations. :)
Going back to the first requirement, is the makeup always the same 2-4-4-4-2.
If so, the first formula can be simplified:
=LEFT(B2,8)&"ABC"&MID(B2,1 3,LEN(B2))
If so, the first formula can be simplified:
=LEFT(B2,8)&"ABC"&MID(B2,1
ASKER
Yes, that is much better, Thanks again!!
No worries, thanks for the feedback. Maybe I should have asked about the make up before giving the more complicated formula.
ASKER
and I need to change all the characters in the 9th position an X 11-2000-X528-3001-02
again the 9th character is not always the same currently