Posted to microsoft.public.excel.programming

tom_mcd[_2_] tom_mcd[_2_] is offline

external usenet poster

Posts: 12

len replace function

...........<__LLLL......<__..........<__....... ...<__..
.........LL<__LL........<__..........<__....... ...<__..
...........<__LL........<__..........<__....... ...<__..
HI all, above is a string with each character representing a date in a
month. I would like to be able to repalce each character with a number. For
e.g. in the first string the 1st < would be number 11, the 1st L would be
number 14 etc.They would also be in separate cells. Any ideas. Thaks again in
anticipation. Regards

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
Can you have a value created by a function replace the function?	xak1222	Excel Worksheet Functions	3	September 10th 09 09:37 AM
Replace function	anandmr65	Excel Discussion (Misc queries)	1	May 10th 06 01:36 PM
REPLACE Function	Scott	Excel Worksheet Functions	4	October 26th 05 07:34 AM
How i can replace function	Luka	Excel Worksheet Functions	3	December 27th 04 09:04 PM
Replace XLA with XLL function	Jens Thiel[_2_]	Excel Programming	12	September 22nd 04 02:17 PM

All times are GMT +1. The time now is 03:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us