Hi, I would like to split a number, for example, 100012258, into individual cells. I want to read this number from a barcode, and I still need to find a solution for that, but it just enters the number into a cell. Does anyone have any ideas?
(1 votes)
Loading...Hello, I'm taking my physics exam in nine days and I know absolutely nothing, literally nothing. I've looked at a few topics with videos and books and then tried to solve the exam problems, but I can't even come close to solving any of them. Do you have any tips? Greetings
Could someone please help me calculate the extreme and turning points from task A and B step Any step-by-step instructions so I can do C and D on my own? 🥺 I would be very grateful.. Unfortunately, I'm having trouble with math.🙁
How can I rearrange the formula DELTA L = L 0 • Alpha • DELTA T so that I get L 0 = ?
The Americans have a different system of measurement, with miles instead of kilometers, as you know. But do they also have different formulas? For example, we have the formula v=s/t. Is that the same for the Americans?
Good day everybody, How should I proceed when calculating such a kinematics or dynamics problem? At this point, I'm having trouble understanding how to proceed with a coupling problem and how exactly to calculate the force in such a problem. Is the way I've drawn the force arrows correct? And how should I proceed to…
Possibilities there are 2025 times many, as GutenTag2003 has suggested state solutions
or dynamic such as Callidus89 part but also right/left
or also things Textvor/Textnach, which combines a little bit of search/finding, but is only available in Excel 2024
This is possible with the function =part(…).
for example
Data – text in columns – separated – fixed width
That works so wonderful. Can I use it automatically? So that I bsp the first cell select the 9-digit number and as soon as I leave the cell he writes it into the individual cells?
Thank you so much
If you should always be separated after the same division, you could create a macro for it.
.
This goes for all cells at once when you mark the range/column and then – data text in columns …
for example, column A, all numbers are divided
Moin, I’ve tried this now, and he’s taking all the data I enter in column A and letting “spread” in line 12 (the first row in the macro)… But he makes it semi-automatic (stop with shortcut)… Now the problem is that if I want the number in line 16 to be spread in line 16…