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: 2
Default VB Function Needed - Differentiate between a number and a characte

Hello,

Trying to setup a simple code to rearrange some data. The data looks like:

blah blah
123
33
222
123
44
22
blah blah

What I'm doing is moving all of the data into one line. The data is always
in groups of threes with text strings thrown into random rows in between the
groups of three. I have a VB script set to reorganize the data, however I
can't find a function or appropriate method to tell whether the cell that is
currently selected contains a number or character string. Can you offer any
help or ideas?

Thank you!
Iffy
 
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
Function that can differentiate between text & numbers??? Kevin Excel Discussion (Misc queries) 7 April 4th 23 02:23 PM
Differentiate between Number and Date? Merle Excel Discussion (Misc queries) 11 January 16th 06 08:46 AM
Remove Box or Squre Characte from Cells Corey Excel Discussion (Misc queries) 1 November 15th 05 05:36 PM
How do I view all data in a cell regardless of number of characte. DavidMarquez Excel Discussion (Misc queries) 2 July 22nd 05 09:23 PM
How do I use COUNTIF in a SUBTOTAL function to differentiate the . Lettie Excel Worksheet Functions 6 March 22nd 05 08:47 AM


All times are GMT +1. The time now is 01:45 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"