Excel Column name issue - Same column name giving extra space in it

[sybasha (syed)]

Hi,
@Palaniyappan @KarthikByggari @karthi2612

I have a code developed in re framework. now i am doing small modifications to code in between. I am getting data from 3 different tabs and merging into one data table to compare with another data table further. when merging i have a issue with list price column like in the picture attached, 2 tabs are giving listprice columns correctly according to the further code. But the 3rd tab is giving space in List Price which is throwing the bot off in further code and giving exceptions.

I dont want to change the further code as it contains lot of validations and also big. I want to fix at the columns name in data table, how to merge both columns ? can anyone help me. Thanks

[Srini84 (Srinivas Kadamati)]

@sybasha

columns name in data table, how to merge both column

@sybasha

Instead of space can you make it “_”

Hope this solves your issue

Thanks

[sybasha (syed)]

changed the column name of the odd data table and it worked