Text to columns ?

  • Thread starter Thread starter Ken Wright
  • Start date Start date
K

Ken Wright

You don't need to, as it can be done with a formula quite easily. Data / text To Columns
will do it by using Data / text To Columns / delimited / Check 'Space' as delimiter and
hit next and finish. Downside is that the rest of your data will also be split whervere
there was a space in the data and you will have to recombine it using concatenation.

Using a formula, assuming your data starts in A1, in B1 put the following formula and copy
down:-

=LEFT(A1,LEN(A1)-6)
 
How can I use text to columns to separate the work TOTAL from a list that
looks like the one below. The names are all different spacings:

GROGG WORKS Total

WESTLAKE AUDIO Total
BE MEDIA Total
GROGG WORKS Total
WESTLAKE AUDIO Total
PRO SOUND LAS VEGAS Total
GROGG WORKS Total

WESTLAKE AUDIO Total
COMPVIEW Total
VIZUAL SYMPHONY, INC
GROGG WORKS Total
SOUND IMAGE INC Total
GROGG WORKS Total
SOUND IMAGE INC Total
GROGG WORKS Total
SOUND IMAGE INC Total
GROGG WORKS Total
SOUND IMAGE INC Total
 
One way is to use Edit>Replace

Find what =Total
replace with = leave this empty

You can use a formula like this
=LEFT(A1,LEN(A1)-5)
 
Back
Top