Questions tagged [text-to-column]
72 questions
0
votes
0 answers
VBA - Yahoo finance double quotes in CSV but missing in import
I have a VBA macro importing stock information from Yahoo finance. From the URL i can manually download the CSV where the stock name has double quotes (e.g. "iShares J,P. Morgan USD Emergin").
The code runs the following:
Sub…
Florian Faucher
- 1
- 1
0
votes
1 answer
Splitting information from a cell
My sheet contains three types of cells:
5off
50off
550off
What they should read is:
$5.00 Off
$0.50 Off
$5.50 Off
I've been fighting with Text-to-Columns and =concat for a while and am trying to get this to work as easily as possible. Any ideas?
A_weit
- 1
- 2
0
votes
0 answers
String vector to unique columns by delimiter in R
I have a data frame with a vector that has multiple combinations of strings separated by a delimiter ";" without any sequential order to the strings in that vector. I would like to know if there is a way to separate the strings in that vector by the…
user3594490
- 1,949
- 2
- 20
- 26
0
votes
2 answers
Text to Column change as Text to row
Have some new data to workout with Text to rows format.
In normal we will use text delimiter in excel to split the data from one column.
I am in need of the same feature in row wise.
example
List of location in a column.
CHARLESTON, JACKSONVILLE,…
Mike
- 3
- 6
0
votes
0 answers
VLookup Won't work in Excel after Parsing Text
I've created an editable link to my Excel workbook here:
https://1drv.ms/x/s!Ai_INzFRkuU2jV_Gcv3wSI0uwwBZ
My objective is to create a column in the "DK" sheet, column "I", that returns the weekly, percentile-ranking of each respective player. The…
DataProphets
- 156
- 3
- 17
-1
votes
1 answer
Text To Columns VBA
I'm trying the text to column but seems I have a error. This is my Code:
Set rg = Range("H3:H" & lr).CurrentRegion
rg.TextToColumns _
Destination:=Range("H3"), _
DataType:=xlDelimited, _
Tab:=False, _
Semicolon:=False, _
Comma:=False,…
cyrnsnpdr
- 15
- 4
-1
votes
1 answer
VBA won't run on cells unless converted from Text to Columns
I have a VBA that selects specific columns to create a chart. I was having an issue where certain columns would be omitted from the chart and I didn't know why. After troubleshooting, I found that once the omitted columns were converted from Text to…
Zacchini
- 143
- 13
-1
votes
1 answer
Data integration: combine monthly trial balances
I'm fairly new to the data integration part of R, and in this instance I am trying to convert monthly financial trial balances into a flat file such that it is ready to go for further analyses. The input data can be seen on the attached picture. It…
PC Enge
- 1
-1
votes
1 answer
Text to Column to Different Sheet
I'm trying to do a text to column from one sheet to another and the below code is not copying the data from the active sheet over to the destination... I am using code generated from the macro
Private Function ConvertText(rngSource As Range)
…
Maldred
- 1,074
- 4
- 11
- 33
-1
votes
2 answers
Split comma separated string/value to columns
I have comma separated CODE value in column "A2" and "A3"
Screenshot 1
I want to split the comma separated CODE values to SP_1,SP_2 ... SP_10 columns like as the below screenshot
Screenshot 2
Is there any formula to do this?
Sumon Sarker
- 2,707
- 1
- 23
- 36
-3
votes
2 answers
Extract multiple strings between brackets or two different delimiters
I'm trying to extract data between these two delimiters [,]
for two cases: Beginning with #CB or CR:
Input data:
Scenario,Order_ID,Review
1,1234,Food was good 7890 [#CB:Customer happy with…
Storm
- 1
- 3
-3
votes
1 answer
How to perform text to column on SQL Server
I have a column that includes all the account groups and delimit by space. I want to split all these groups into each new column, similar to the 'Text to Columns' tool on excel that can split a single column of text into multiple columns and assign…
MrMuffin
- 53
- 1
- 2
- 7