#1
|
|||
|
|||
Seperating text data
Have following in A1
"Bloggs,Joe" < Joebloggs@gmail.com> want to seperate so have A1" Bloggs ,Joe" B1 Joebloggs@gmail.com any suggestions appreciated |
#2
|
||||
|
||||
Select the column with Data
Data - Text to columns - Check "Delimited" - Next Check"space" - Check " others and enter > -Next Select the column containing the < and check " do not import" Finish
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
works great for A1 but how do I do it for A1 to A100 ???
New to this game sorry |
#4
|
|||
|
|||
What you can do is this:
Select all data: replace all " for nothing. you will get: Bloggs, Joe <bloggsjoe@gmail.com> Select all data: replace all > for nothing you will get: Bloggs, Joe <bloggsjoe@gmail.com Write in B1: =LEFT(A1;SEARCH(" <";A1;1)) (you might need to change the seperator ; for ,) Write in C1: =RIGHT(A1;LEN(A1)-FIND("<";A1)) (you might need to change the seperator ; for ,) Drag that to B100 and to C100 |
#5
|
||||
|
||||
If you read my post carefully it begins with " select the column with the data"...Thus, select a1:a100 and perform the suggested solution
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting data-table into coding text | niuri_cigarete | Excel | 2 | 12-10-2011 02:57 AM |
How to count the total cells that contains text data? | Learner7 | Excel | 1 | 06-30-2011 04:13 PM |
Losing Text box data when copy and paste | Spay | Excel | 0 | 03-15-2011 07:18 AM |
Use changeable table data in doc text? | rtlight | Word Tables | 4 | 02-25-2011 07:29 PM |
extracting data from Table to text file | Anirudh_Dsp | Word Tables | 1 | 05-23-2010 07:48 AM |