Right, Left, Mid

bschulze

Active Member
Joined
Jun 2, 2005
Messages
289
I am looking for a right, left, mid function that goes up a a certain variable. For instance, I have a cell that needs to be broken out into two cells, The seperation indicator is "#". I have been playing around with it and can not get this to work. I know that it is simple but my brain is not functioning today.

Example:
Column A Column B
111#2222 I need 111 2222
3#1 I need 3 1


Sorry I am wasteing a post on this.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Try

=LEFT(A1,FIND("#",A1)-1)

and

=REPLACE(A1,1,FIND("#",A1),"")

or use Data > Text to Columns with # as delimiter
 

Asala42

Well-known Member
Joined
Feb 26, 2002
Messages
2,318
Data/Text to Columns can do it if you don't mind a non-formula approach.

Formula Wise I'd go with a left(find) kind of thing:

=LEFT(A2,FIND("#",A2)-1)
=RIGHT(A2,LEN(A2)-LEN(B2)-1)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,758
Messages
5,574,069
Members
412,566
Latest member
TexasTony
Top