Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Blanks
I need to insert 2 blanks into some data ,,, e.g. 0001234, I want it to be
able to see 000 1234. Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Blanks
John Moore wrote:
I need to insert 2 blanks into some data ,,, e.g. 0001234, I want it to be able to see 000 1234. Can anyone help? Lots of unanswered questions here! If the data is always 7 characters then you can do: =LEFT(data,3)&" "&RIGHT(data,4) If you always want to insert after the first 3 characters do: =LEFT(data,3)&" "&MID(data,4,LEN(data)) I could go on depending on what exactly the requirements are (e.g. put the blanks before the last 4 characters). Also this presupposes that you wish to do this using a formula and then maybe use copy and Paste Special-Values to replace the data. You might want a macro to do it. Let us know if the above is not spot on. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting blanks or changing dimensions | Excel Worksheet Functions | |||
linking files with blanks | Excel Discussion (Misc queries) | |||
insert a JPEG into EXCEL 2002 | Excel Discussion (Misc queries) | |||
insert picture | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |