ExcelBanter - help about function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - help about function (https://www.excelbanter.com/excel-worksheet-functions/101940-help-about-function.html)

lunar_star

help about function

i have my data in A3:A7

HD-01-01
SP-126-01
HD-02-05
CD-80-04
GD-1000-01

and B3:B7
10000
20000
30000
40000
50000

i want take any char between -*-

--
lunar_star
------------------------------------------------------------------------
lunar_star's Profile: http://www.excelforum.com/member.php...o&userid=36882
View this thread: http://www.excelforum.com/showthread...hreadid=565978

Barb Reinhardt

help about function

=LEFT(RIGHT(A3,LEN(A3)-SEARCH("-",A3)),SEARCH("-",RIGHT(A3,LEN(A3)-SEARCH("-",A3)))-1)

"lunar_star" wrote:

i have my data in A3:A7

HD-01-01
SP-126-01
HD-02-05
CD-80-04
GD-1000-01

and B3:B7
10000
20000
30000
40000
50000

i want take any char between -*-

--
lunar_star
------------------------------------------------------------------------
lunar_star's Profile: http://www.excelforum.com/member.php...o&userid=36882
View this thread: http://www.excelforum.com/showthread...hreadid=565978

lunar_star

help about function

i want sum money in with

HD | SP | CD | GD

--
lunar_star
------------------------------------------------------------------------
lunar_star's Profile: http://www.excelforum.com/member.php...o&userid=36882
View this thread: http://www.excelforum.com/showthread...hreadid=565978

All times are GMT +1. The time now is 11:39 PM.