Solved How to copy only part of a cell. Text are delimited

May 9, 2014 at 06:05:49
Specs: Windows 8
Hi.

Pls, I have on a column B the text: [Client] - Project - Bla bla bla bla
I need the column C shows only Client.
Any idea how can I solve it?
Thanks!


See More: How to copy only part of a cell. Text are delimited

Report •


#1
May 9, 2014 at 07:59:34
Sorry missread your post the first time.
Try this in column C

=LEFT(B1,8)

Not sure if you want the Brackets around the word client, so I left them in.

If you do not want the Brackets around the word client then use this one:

=MID(B1,2,6)

Just drag down as many rows as needed.

EDIT ADDED:

Don't forget to do a Copy/Paste/Values on column C so you lock in the values.


MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
May 9, 2014 at 16:12:49
Are you really trying to extract the string "Client" or is "Client" a stand-in for actual client names, e.g.

[Acme Wholesale] - Project - Bla bla bla bla
[Wile E. Coyote] - Project - Bla bla bla bla
[Road Runner] - Project - Bla bla bla bla

Are the brackets actually part of the overall string, or does your data really look more like this...

Acme Wholesale - Project - Bla bla bla bla
Wile E. Coyote - Project - Bla bla bla bla
Road Runner - Project - Bla bla bla bla

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
May 9, 2014 at 17:21:31
✔ Best Answer
DerbyDad03 has a point. I did not consider that the word Client was simply an example.

With that in mind, if the clients name is between the brackets like:

                   A
1) [Acme Wholesale] - Project - Bla bla bla bla
2) [Wile E. Coyote] - Project - Bla bla bla bla
3) [Road Runner] - Project - Bla bla bla bla

Then in cell B1 enter the formula:

= MID(A1, FIND( "[", A1) + 1, SUM( FIND( {"[","]"}, A1) * {-1,1}) - 1 )

That should give you just the clients name without the brackets.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question