Question description:
This user has given permission to use the problem statement for this
blog.
When I past a line of text into excel, where there is a space, it puts the data in to a separate column. Can you assist?
Solved by S. B. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
23/04/2018 - 02:07
Hi there!
User
23/04/2018 - 02:07
Hi
Excelchat Expert
23/04/2018 - 02:07
I was wondering if I might be able to see the file you're working with - or even the line of text that you're trying to copy?
User
23/04/2018 - 02:08
INJECTOR ASSEMBLY KIT 24KW
User
23/04/2018 - 02:08
it is putting it into 4 separate columns and don't want to use flash fill. My colleagues is doing the same and her system is ok.
Excelchat Expert
23/04/2018 - 02:08
And this text - you're trying to paste it into one single cell?
User
23/04/2018 - 02:08
Yes
Excelchat Expert
23/04/2018 - 02:09
Oh weird that it's working for your colleague!
User
23/04/2018 - 02:09
and for you it would appear
Excelchat Expert
23/04/2018 - 02:09
That is very odd.
Excelchat Expert
23/04/2018 - 02:09
Are you perhaps able to share your actual Excel file?
Excelchat Expert
23/04/2018 - 02:10
A test I was just thinking of as well would be to open a blank Excel file and try and copy/paste into a cell and see if it works
Excelchat Expert
23/04/2018 - 02:10
Then we know it's something in the sheet itself (setting or something)
User
23/04/2018 - 02:10
done that, to no avail :-(
User
23/04/2018 - 02:10
it has worked earlier, but now it seems to have changed.
Excelchat Expert
23/04/2018 - 02:10
Are you able to share the file? Or is it confidential?
Excelchat Expert
23/04/2018 - 02:11
So odd!
User
23/04/2018 - 02:11
it is confi
Excelchat Expert
23/04/2018 - 02:11
so you did the test to a new sheet and it's still copying to 4 cells?
User
23/04/2018 - 02:11
yes it did
Excelchat Expert
23/04/2018 - 02:12
Strange. Ok let me look into this real quick - one sec!
User
23/04/2018 - 02:14
I have sorted it thank you.
Excelchat Expert
23/04/2018 - 02:14
Oh wow beautiful!
Excelchat Expert
23/04/2018 - 02:14
You're a star.
Excelchat Expert
23/04/2018 - 02:15
Sorry I was too slow.
Excelchat Expert
23/04/2018 - 02:15
Feel free to ping us back if you need further assistance
User
23/04/2018 - 02:15
not a problem
User
23/04/2018 - 02:15
have a good day
Excelchat Expert
23/04/2018 - 02:15
Have a great day ~
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
