-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
text to columnns
-
A
"text to columns" with numbers
I have cells that contain multiple values as a full string: Apple - Banana - 000123 When I convert to three columns using the "text to columns" operation, the third column converts to a number and removes the leading zeros (cell value turns into 123 as a number). This is breaking my lookup...- alfordtp
- Thread
- number and text numbers as text text to columnns
- Replies: 4
- Forum: Excel Questions
-
M
Help with import TXT files with transposed lines into columns
Hey guys, I need your help with this case (sorry for the bad english :) ) I have this TXT file with payment details for each person divided by a line containing the name and year of the record, a new line with CPF number, and columns for each type of record (there are 7 colums, with headers)...- MarcusOliveira
- Thread
- line break text to columnns text to excel transpose vba & txt
- Replies: 3
- Forum: Excel Questions
-
How to split number from this text seperately using formual
Hi Team, Please help me to split the number seperately from this text "Project ABC12Limited (9874) - Test ok" I have this text in A1, i want 9874 only in A2, i used mid function but if MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),4) but i am unable to get the exact output, Please...- Learn Excel in Tamil
- Thread
- excel formula seperately split number in excel text text to columnns
- Replies: 7
- Forum: Excel Questions
-
P
Excel help - much appreciated!
I have a question - I have a data set that currently looks like this Product A | Sales person a, sales person b Product B | Sales person a, sales person c Product C | Sales person b, sales person d, sales person e I need a report that looks like this (reverse of what I have above) Sales...- phxomega
- Thread
- person pivot reversed data. sales text to columnns
- Replies: 3
- Forum: Excel Questions
