seperate items in a cell

[still learning]

Hi,
I have the following in cells A1:a200:
abced=12345
efghi=12222
japfr=566232556
the amount of letters before the = sign is always the same, only the length of the number changes
Could I have a macro delete the letters and = sign and leave only the numbers, either in A or in B?
I only gave 3 examples because i didn't want to use up too much room

Mike

 

[crook_101]

Hi,

As there is only 200 rows, a formula solution would be in B1 and copied down:

=RIGHT(A1,FIND("=",A1)-1)

HTH
Ian

 

[still learning]

Hi crook_101
The formula works good until the length of numbers change after the = sign. Also, I had to change the "1" to delete some of the text.


Mike

 

[Dryver14]

Hi Crook_101

try this

=RIGHT(A1,LEN(A1)-6)

 

[AlphaFrog]

You could also use the Replace feature...

• Select your cells A1:A200
• Select from the menu; Edit\ Replace (Ctrl+H)
  • Replace what: *=
  • Replace with: < leave blank >
  • Replace All

 

[still learning]

Thank you all for the help
I didn't know that I could use "find/replace" that way.

Mike

 

[scottylad2]

variation

Excel Workbook
	A	B
15	japfr=566232556	566232556
16	02154685japfr=2557	2557
17	japfr=566232558	566232558
18	japfr=566232559	566232559
19	japfr=566232560	566232560
20	llsdjdjfjhfriroeojapfr=566232561	566232561
21	japfr=566232562	566232562
22	japfr=566232563	566232563
23	japfr=566232564	566232564
24	japfr=566232565	566232565
Sheet1