LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Ignoring Certain Characters In a Cell Using VBA


I have a problem with some code I have. It is setup right now so that
data entered into column A must match or it is then moved to column B.
The data in column A is always going to be 13 characters long

The problem is the last 5 digits of the data are always going to be
different and the first 8 are always going to be the same. So basically
the code needs to be setup to recognize the first 8 digits of data and
ignore the last 5.

Is there any simple way to do that?


--
Lil Pun
------------------------------------------------------------------------
Lil Pun's Profile: http://www.excelforum.com/member.php...o&userid=33840
View this thread: http://www.excelforum.com/showthread...hreadid=549758

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Sorting characters, ignoring numbers Barto9729 Excel Worksheet Functions 7 September 25th 13 07:08 PM
ignoring text data in a cell when summing values in the same cell FM New Users to Excel 2 February 24th 10 02:51 AM
convert 5 characters in a cell to 6 characters by adding a zero Helenf Excel Discussion (Misc queries) 4 May 18th 09 04:43 PM
Ignoring characters when sorting amy153 Excel Discussion (Misc queries) 0 February 14th 06 09:20 PM
Ignoring characters in excel sheets when creating a chart smintey Charts and Charting in Excel 2 December 7th 04 06:17 PM


All times are GMT +1. The time now is 06:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"