Posted to microsoft.public.excel.misc

Christy

external usenet poster

Posts: 89

How do I replace last numeric string from a alphanumeric string?

For example,
I want to replace "1055428" from CC03TW05040000010001055428 with "1162123",
so that my string would be CC03TW05040000010001162123.

Thanks!

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
random alphanumeric string	[email protected]	Excel Worksheet Functions	4	April 21st 23 09:04 AM
Numeric cell but shows as string?	Brett	Excel Worksheet Functions	9	March 24th 05 11:56 AM
Summing part of an Alpha Numeric String	Arturo	Excel Worksheet Functions	2	February 23rd 05 09:59 PM
Read Text File into Excel Using VBA	Willie T	Excel Discussion (Misc queries)	13	January 8th 05 12:37 AM
Extracting numeric values from string	RJF	Excel Worksheet Functions	3	January 5th 05 10:48 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us