Search Results

all thanks for the help thus far.

i will test tomorrow.

best,
DL

hi vgresh,

Here is a representative sample attached (input worksheet).
Desired output is on the output worksheet.

vgresh thank you. i'm goign to see if i can use your code. The file in question actually has 1.3million rows (tab delimited). the source column is number 35, and I need to append the 123 and abc...

How could i take an input file and split the numeric values from the alpha values (123 vs abc) to distinc columns, and if the source is blank to keep it blank (null) in both of the new columns:
...