Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function that can differentiate between text & numbers??? | Excel Discussion (Misc queries) | |||
Differentiate between Number and Date? | Excel Discussion (Misc queries) | |||
Remove Box or Squre Characte from Cells | Excel Discussion (Misc queries) | |||
How do I view all data in a cell regardless of number of characte. | Excel Discussion (Misc queries) | |||
How do I use COUNTIF in a SUBTOTAL function to differentiate the . | Excel Worksheet Functions |