Posted to microsoft.public.excel.programming

Peter[_61_] Peter[_61_] is offline

external usenet poster

Posts: 48

Adding spaces into a variable

I have a problem!

I am writing a macro where the user pastes in a 16 digit number into a
text box on a user form.
This then becomes a variable (long).

I need the macro to edit this variable by placing a space after the
4th, 8th and 12th number.

ie, from this: ################ to this: #### #### #### ####.

Is this possible?

Thanks,

Peter

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
adding spaces	John K	Excel Discussion (Misc queries)	5	April 8th 10 03:49 PM
Adding Spaces to the end of a value	JohnGuts	Excel Worksheet Functions	4	July 30th 06 09:50 PM
Adding spaces to a cell	catalfamo1220	Excel Discussion (Misc queries)	3	July 18th 06 04:03 PM
Remove spaces from a string variable	blatham[_2_]	Excel Programming	4	August 24th 05 11:29 AM
Remove spaces from a string variable	T-®ex[_4_]	Excel Programming	0	August 24th 05 09:25 AM

All times are GMT +1. The time now is 08:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us