Thread: How do I replace last numeric string from a alphanumeric string?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
VBA Noob VBA Noob is offline
external usenet poster
  
Posts: 1
Default How do I replace last numeric string from a alphanumeric string?

Hi,

Say

A1 = CC03TW05040000010001055428
B1 = 1162123

then enter C1

=LEFT(A5,LEN(A5)-LEN(B5))&B5

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=570561

Reply With QuoteReply With Quote