Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Parsing Data with Formulas (vs Text-to-Columns)
I have data that looks like this:
ColA ColB tag12!=2005 tag33!=1 is there a formula that I can place in ColB and C that will take just the data to the right of the "=" character ? Thank you in advance. |
#2
|
|||
|
|||
Hi
=MID(A1,FIND("=",A1)+1,255) -- Regards Frank Kabel Frankfurt, Germany "carl" schrieb im Newsbeitrag ... I have data that looks like this: ColA ColB tag12!=2005 tag33!=1 is there a formula that I can place in ColB and C that will take just the data to the right of the "=" character ? Thank you in advance. |
#3
|
|||
|
|||
one way:
=MID(A1,FIND("=",A1)+1,255) where 255 is just a big number. In article , "carl" wrote: I have data that looks like this: ColA ColB tag12!=2005 tag33!=1 is there a formula that I can place in ColB and C that will take just the data to the right of the "=" character ? Thank you in advance. |
#4
|
|||
|
|||
You can use
=MID(A1,FIND("=",A1)+1,999999) and you can place a "--" (no quotes) before the MID to make them look like numbers. "carl" wrote in message ... I have data that looks like this: ColA ColB tag12!=2005 tag33!=1 is there a formula that I can place in ColB and C that will take just the data to the right of the "=" character ? Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Data Text to Columns | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Lookup Data in Several Columns | Excel Worksheet Functions |