| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert colon in text in cell
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert colon in text in cell
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" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert colon in text in cell
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert colon in text in cell
Thanx guys! Phoenix -- Phoenix ------------------------------------------------------------------------ Phoenix's Profile: http://www.excelforum.com/member.php...fo&userid=2921 View this thread: http://www.excelforum.com/showthread...hreadid=507993 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert colon in text in cell
You're welcome !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Phoenix" wrote in message ... Thanx guys! Phoenix |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shade cell according to text? | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Need macro to insert text string while inside cell (formula) | Excel Discussion (Misc queries) | |||
| On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Hybrid Mode
