I have been asked to upload leads into SL, the only problem is there are multiple leads all in one row.(see below). Would anyone know how to split these emails so they are in there own cells?
I have tried =textsplit and =transpose with no luck.
djimenez@hps.org
jmcintyre@hps.org
bfiordalis@hps.org
nharber@hps.org
Any help would be greatly appriciated.
Matt
#Salesforce Admin
2 answers
Hi @Matt Laird
You just need to split the values into separate cells (or rows) properly.
Solution 1: Using Excel (Text to Columns)
If all emails are in one cell separated by line breaks:
- Select the cell
- Go to Data → Text to Columns
- Choose Delimited → Next
- Select Other
- Press Ctrl + J (this inserts a line break delimiter)
- Click Finish
This will split each email into separate columns
Solution 2: Convert into Rows (Best for Salesforce Upload)Salesforce usually needs one record per row, so:
After splitting into columns:
- Copy the split data
- Paste into a new sheet
- Use Paste Special → Transpose
OR
Use this formula (Excel 365): =TEXTSPLIT(A1,CHAR(10))
Then copy → paste as values → convert to rows if needed
