Getting warning message in Text to Columns

Prasad K

Board Regular
Joined
Aug 4, 2021
Messages
189
Office Version
  1. 2016
  2. 2007
Platform
  1. Windows
Hi Excel Experts
I need help from you
I have getting warning message on Text to columns

When I am applied text to columns on my data to split to multiple columns
Then I will getting warning ( There's already data here Do you want to replace it )

Here i have changed settings in my excel file & options & advanced & unchecked the alert before overwriting cells also

Again still i getting same error
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
It is most likely you have data occupied in column on the right to the column you want to split.

In example below, when you split, data need to occupy column A, B, and C but you already have data in C. So, you get that message. If you continue, it will overwrite the data in column C
Book1
ABC
1a,b,cd
2
Sheet1
 
Upvote 0
It is most likely you have data occupied in column on the right to the column you want to split.

In example below, when you split, data need to occupy column A, B, and C but you already have data in C. So, you get that message. If you continue, it will overwrite the data in column C
Book1
ABC
1a,b,cd
2
Sheet1
No i have no data in column c

Here my data look like

In column A
Arun,kumar
Sanju,goud

When I applied text to columns in my data in col A i have getting warning

Kindly please help
 
Upvote 0
No i have no data in column c

Here my data look like

In column A
Arun,kumar
Sanju,goud

When I applied text to columns in my data in col A i have getting warning

Kindly please help
Maybe got space accidentally. What happened if you just continue to overwrite or delete whole page and try again?
 
Upvote 0
Maybe got space accidentally. What happened if you just continue to overwrite or delete whole page and try again?
Ok zot

I have moved total data to new sheet now it's not showing warning

Actually i got that workbook download from email

Thankyou so much and sorry for disturb
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top