Output column with 2 data types into excel

I have a column that consists of string and numeric data, and I need to output it into a template excel file. Said excel file has different formulas that calculate values based on data.

The problem is that numeric data is outputed as string data in excel, so formulas based on numeric data don't work. Is there a way to output it in the excel and somehow update or refresh numbers?

Output

Transformation

Accepted answers

apathetichell

when @OTrieger wrote "One way to do it is to save the data into ranges" this was a polite shorthand for "You must write to specific cells/ranges and preserve formatting --- google how to use an excel template and blob tools to make new fields if needed. You must know the underlying formatting of the cells you are trying to write to and the specific location."

The above is the way. It is the only way. Learn how to do it - or figure out another workaround in Excel.

All comments

OTrieger

@Frndly

One way to do it is to save the data into ranges, in this way you can save string as string and numeric as numeric, it will only require that you will output the data multiple times to different ranges.

Frndly

I considered it. The, but there's no consistent range of numeric\string data. I've attached an example. Distribution of numeric\string data can be considered random, although the amount of cells(height\width of the table) is consistent.

Screenshot 2025-05-06 143435.png

apathetichell

The above is the way. It is the only way. Learn how to do it - or figure out another workaround in Excel.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703