LinkBack URL
About LinkBacks
Dont quite understand them...
How can I get this.... CPBL_CFRS_000001_B2
....from a cell that currently states CPBLCFRS000001B2.
I have over 100 to edit and dont want to manually edit 1 by 1!
Thanks
Alun
Dont quite understand them...
How can I get this.... CPBL_CFRS_000001_B2
....from a cell that currently states CPBLCFRS000001B2.
I have over 100 to edit and dont want to manually edit 1 by 1!
Thanks
Alun
How representative is the example you have shown? Is it always 4 characters, 4 characters, 6 digits and 2 characters?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
yes always that format
But I need the underscore within each section _
Try this, then...
=REPLACE(REPLACE(REPLACE(A1,5,0,"_"),10,0,"_"),17,0,"_")
assuming data in A1
Try this:
=LEFT(A1,4)&"_"&MID(A1,5,4)&"_"&MID(A1,9,6)&"_"&RIGHT(A1,2)
assuming your text string is in A1.
Hope this helps.
Pete
Perfect thanks Pete
=LEFT(A1,4)&"_"&MID(A1,5,4)&"_"&MID(A1,9,6)&"_"&RIGHT(A1,2)
This is perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks