didnt't know what to search to find it on the forum, so here is the problem.
I need to insert colon to places to the left, like "X12345"="X123:45",
and "X1234"="X12:34" etc.
I'm sure it's a simple answer for you guys, but not for me
didnt't know what to search to find it on the forum, so here is the problem.
I need to insert colon to places to the left, like "X12345"="X123:45",
and "X1234"="X12:34" etc.
I'm sure it's a simple answer for you guys, but not for me
One way, assuming source data in A1 down
put in B1: =LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2)
Copy B1 down
Freeze col B with an in-place: Copy > Paste special > Check "Values" > OK
Then delete col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Phoenix" <[email protected]> wrote in
message news:[email protected]...
>
> didnt't know what to search to find it on the forum, so here is the
> problem.
>
>
> I need to insert colon to places to the left, like "X12345"="X123:45",
>
> and "X1234"="X12:34" etc.
>
> I'm sure it's a simple answer for you guys, but not for me
>
>
> --
> Phoenix
> ------------------------------------------------------------------------
> Phoenix's Profile:
http://www.excelforum.com/member.php...fo&userid=2921
> View this thread: http://www.excelforum.com/showthread...hreadid=507993
>
Hi Phoenix,
If A1 contains X12345 then =LEFT(A1,LEN(A1)-2) & ":" & RIGHT(A1,2)
pasted into any other cell will result in that cell displaying X123:45
Ken Johnson
Thanx guys!
Phoenix
You're welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Phoenix" <[email protected]> wrote in
message news:[email protected]...
>
> Thanx guys!
>
> Phoenix
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks