Macro for Extracting Data

Closed

MHerren Posts 1 Registration date Tuesday March 24, 2015 Status Member Last seen March 24, 2015 - Mar 24, 2015 at 09:53 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 24, 2015 at 12:40 PM

I need helping writing a macro to extract data from column A and input into column B. Example data = 13A:123456789:V1 and what I need is the data between ":", most of the time 9 digits, but sometimes more (so more accurate to state between ":". Once this data is extracted I want it placed in column B, corresponding cells. So it would be original data in A, new extracted data in B. The range is the entire column. Can someone please help?

Macro for Extracting Data
Transfer data from one excel worksheet to another automatically - Guide
Spell number in excel without macro - Guide
Tmobile data check - Guide
Macro excel download - Download - Spreadsheets
Run macro when cell value changes - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
Mar 24, 2015 at 12:40 PM

Hi MHerren,

No need for macro here.

The following formula will locate both ":" and takes the value in between:
=MID(A1,SEARCH(":",A1)+1,SEARCH(":",A1,SEARCH(":",A1)+1)-(SEARCH(":",A1)+1))

Best regards,
Trowa

Similar discussions

copy a row from one worksheet to another, based on criteria

Spreadsheet data

macro for inserting multiple rows between data

Hosted app data will not clear

Similar discussions

Subscribe To Our Newsletter!